Problem with Search Boxes

[Gasman]

You place a breakpoint in the code in that event procedure, then run the form as normal.
That will take you into that procedure and walk the code line by line with F8.

Place a Debug.Print of the filter string before you try and use the filter and see what it produces.
An AND is only valid for subsequent extra filter strings, NOT the first string.

 

[theDBguy]

I watched the video, and the terms make sense now, but applying them to my code is different. I tried adding breaks and a stop to the code to try it out, and it keeps asking me for the name of the macro. There is no macro - the code is an Event Procedure directly from the object.

I also read your comment about the AND not working at the beginning of the code...what is the alternative then, for narrowing down the results?

Hi @Heide. We're two pages in and it seems you still need some help. Just out of curiosity, did you see my comment in Post #13?