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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

passing criteria from form to query 1
Compound Count Problem 2
Multiple Parameter Crosstab query filter by form 1
Passing Form Values to Queries 3
Passing criteria to queries from forms 2
Export query with passed criteria 6
Passing Multi-Select to a Query 2
Query with more than 8 'OR' criteria? 2

Back
Top