Passing form choices to query

L

Lambi000

I have a menu form that allows a user to input from/to dates and to check off
any, all or none of checkboxes for five warehouses; the user can then run a
bunch of different reports.

How can I take the results of the checks and put them into the criteria of a
query? All I need to know is how to make Check87 and Check89 and Check91
translate into "Whse 1" OR "Whse2" OR "Whse3" to put into the query.

Thanks,
 
K

KARL DEWEY

Use an IIF statement in the criteria --
IIF([forms]![yourform]![Check87] = -1, "Whse 1")
 
Top