Queries Access 2003 use a Drop down box for selection of querycrit

[Fdspokane]

I have an application which uses a master viewing form with a couple drop
down combo boxes for the Dataentry people to select variables - like Type of
item or Category.
Accompanying this I have an Item and a Category table which contains the
lookup information.
I would like to create a query which uses these tables in a Drop Down
selection style so the peron doing the query can select this information -
rather than having to type it in.
How would I get this to work in my query ?

 

[Marshall Barton]

I have an application which uses a master viewing form with a couple drop
down combo boxes for the Dataentry people to select variables - like Type of
item or Category.
Accompanying this I have an Item and a Category table which contains the
lookup information.
I would like to create a query which uses these tables in a Drop Down
selection style so the peron doing the query can select this information -
rather than having to type it in.
How would I get this to work in my query ?

You can use a criteria like:

=Forms!masterform.comboItem OR Forms!masterform.comboItem Is
Null

 

[FrankSpokane]

Would I add that in the SQL view of my query and where - At the beginning or
where ?

 

[Marshall Barton]

It should be used in the Criteria row of the item field in
the query design grid. A similar criteria can be used for
the category field.

Make sure that you change it to use the real form and combo
box names.