Query based on Combo box result

[Sgt Bilkp]

I have a query running on a combo box result (select option, run query). No problems here, but i could do with an "ALL" option for the query (the query runs on multiple criteria, such as location, equipment type, status etc and sometimes we want to display all locations, but only faulty equipment).

Is this possible?

 

[Brianwarnock]

If you use the following type of code, then leaving a control with no input ie null will allow you to select all entries.

Brian

Field: [FieldName]=[Forms]![FormName]![ControlName] or [Forms]![FormName]![ControlName] Is Null

Show: uncheck

Criteria: True