Dynamic or Select Query

[SnowB1]

After reading some of what people already had in this forum, I was still left a little confused. Say I have a form with three combo boxes and I want the user to be able to select something from all 3 or just one at a time. Which kind of query should I be using. Right now I have a select query, but it doesn't work right due to the Where Clause, which will work 1 way or the other, but not both(that I know of). Any advice would be appreciated. Thanks.

Bobby

 

[Smart]

Different query to select the list for each combo box

If the user only populates combo box1
run a select query using the value in the combo box1 as a parameter

If the user populates combobox1 and combobox2
run a select query using the values in both comboboxes as parameters

etc

 

[SnowB1]

Doing it this way I will end up with 5 Queries(The county Combo populates and selects the State). Isn't there any other way of doing this with just one query?