I have simple search for where the user checks a check box next to the criteria that they would like to filter by. But I was wonder if there was a way to remove the check box. I have tried If Not IsNull but it does not work. Here is the code that I use.
If chkLegal = True Then
If Nz(Forms![frm_Customer_Search]!txtLegalName, "") <> "" Then
strWhere = "(Legal_Name LIKE '*" & Replace(Forms![frm_Customer_Search]!
txtLegalName, "'", "''") & "*') AND "