I have a database with my contact names in 1 table and the addresses in another. I want to have a search form where I can search on name or address. Trying to do this via a query and having some issues. The main issue is when I open the search form I get a dialog box asking for the "first name" when I close that box another opens asking for "last name" and again it does it on the city. Once I close each of these boxes the actual search form opens where i can type in the contacts I'm trying to search.
I'd prefer to do this via VBA code but not to strong on writing a SQL search. Any thoughts?