[AccessD] Filtering a screen

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


      


More information about the AccessD mailing list