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

F

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 ?
 
F

FrankSpokane

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

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

Drop down list inside a query 6
Multi-select drop-down for a query (Access 2007) 9
Drop down box of saved queries? 4
Drop down Menu for Prompts 2
Using combo box in a form -- how to make drop-down work? 3
Drop Down Properties 1
drop down not allowing selection 6
Multiple Selection from a Combo Box 2

Top