Help filtering form based on the data from another table

[arnelgp]

see your search form (also the code behind the search button).

 

[gojets1721]

@arnelgp awesome! Thank you! Last question, I swear. Let's say I also wanted a 'complaint number' search field in that search form. How would you add that in the code?

I tried adding the below code in but I'm getting an 3075 error.

If Not IsNull(Me.txtComplaintCategory) Then
     sFilter = sFilter & "[ComplaintCategory] ='" & Me.txtComplaintCategory & "'"
End If