Forum Discussion

Tony2021

Iron Contributor

Jan 23, 2025

Solved

Filter Form with Like and Or

Hello Experts, I am having a tough time adding a condition to a filter on a form. It works with 1 condition but not sure about the OR part (sq, dq) Maybe it is correct. The error I get is "T...

access

Kidd_Ip

Jan 24, 2025

Try this:

Private Sub txtEndUser_AfterUpdate()

    ' http://allenbrowne.com/ser-28.html

    If IsNull(Me.txtEndUser) Then
        Me.FilterOn = False
    Else
        Me.Filter = "[Remarks 1] Like '*" & Me.txtEndUser & "*' OR [Remarks 2] Like '*" & Me.txtEndUser & "*'"
        Me.FilterOn = True
    End If

End Sub

George_Hepworth

Silver Contributor

Jan 24, 2025

Have you tried using parentheses to manage the two arguments?

Me.Filter = ("[Remarks 1] Like '*" & [txtEndUser] & "*'") Or ("[Remarks 2] Like '*" & [txtEndUser] & "*'")