Query Design with Multiple Combo Boxes

[Rjc8513]

I have a form with multiple combo boxes. In my query design grid the "WEEK" field's criteria is-

=[Forms].[frmINPUT].[cbxWEEK]

and the "UNIT" field's criteria is-

=[Forms].[frmINPUT].[cbxUNIT]

Is it possible to have all records displayed when the user makes no selection from the "WEEK" and the "UNIT" combo boxes? If so, I would like the user to have the option of not selecting from any of the combo boxes and have all records display? Then, of course, I want the data filtered depending upon choices the user does make from the form's combo boxes.

Thanks.

Richard...

 

[Rjc8513]

Never mind, folks. Figured it out. Thanks.

 

[jpmillr1]

Hi Richard, I was just wondering how you solved this problem, because I want a query to do the same thing.

I have ~7 combo boxes, and want to filter my query based on their choices (or lack thereof for any number of them).

How did you do it? Thanks!