Filter by Form

[Edgar Thoemmes]

I am using a form to filter a query I have designed, I have a check box and a
combo box on the form and a command button.

The Check box is so the user can choose to only select Active Contracts and
the Combo Box will enable the user to select a Commodity Group to filter the
contracts on. The user then makes their choice and hits the command button
which opens the query with the criteria selected on the check box and the
combo box. These controls work fine when the user selects both of the
criteria but if the user doesn’t select a commodity group from the combo box
access displays a blank query.

I am using the following syntax in the criteria field of the query
[forms]![Searchform]![cbosearch]. Is there a way to select all records if the
user doesn’t select anything from the combo box?

Thanks