Dale Kalsow
dkalsow at yahoo.com
Wed Aug 19 10:49:36 CDT 2009
Good Morning, I am filtering the records on the screen with the following code: If Me.cboCustomerHead.Column(0) = "" Then Me.FilterOn = False Else Me.Filter = "tblCustomerToOwner.Customer = '" & Me.cboCustomerHead.Column(0) & "'" Me.FilterOn = True End If This works great but sometimes the item in the cboCustomerHead has a single quote in which then causes an erorr. Does anyone know how I can filter using an item with a single quote? Thanks! Dale