ComboBox Criteria for Query

[CJCESENA]

I am having alot of trouble setting up my comboboxes as criteria for a query. The problem lies in that I want the user to be able to choose any combination of the 5 comboboxes. Meaning that user could choose 2 or 3 or all 5 and leave some blank. I want the selections in the comboboxes to be criteria for the SQL statements. Any suggestions on how I should do that as easily as possible.

Thanks

 

[WayneRyan]

CJ,

I posted a sample database in this thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=74866

There are 4 criteria fields on the form, they aren't combos, but they could
be. I do take it that you are not looking for a "tree structured" search;
that would be "cascading combos". There are examples of that here as well.

Wayne

 

[CJCESENA]

You guys are awesome!! Thanks. Those examples should point me in the right direction.