Passing form choices to query

  • Thread starter Thread starter Lambi000
  • Start date Start date
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,
 
Use an IIF statement in the criteria --
IIF([forms]![yourform]![Check87] = -1, "Whse 1")
 
Back
Top