Hi, I am trying to put together a form so users could query the database for select info, like- customers that have *design* in their name. I figure I can create a query that would use their criteria easy enough, but I want them to be able to pick which field to search for the data in, like customer number, city, state, ect. Once again, I am pretty sure I can use a combo box with a selection of fields for them to search, but the only way I can think to do it is with one query built for each choice, with macros or code to say: if this choice then run this query. I am sure that would work, but I have to figure there is an easier way. Any thoughts?
DAK
DAK