Queries using a drop down field in a dialog box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I run a query, I would like the parameter to use a combo box from one of
the tables I created. I do not want to have to type in the information
because some of the selections are abbreviated and/or long and it would
require everyone using the query to type in the information exactly as it is
shown in the table. How would I do this?
 
Hi JamieM,

Put the combo box on a form and have the users select the required item,
then call the query from there. Let the query pick the value up from the
combo box on the form.

Hope this helps.

Damian.
 
OK...stupid question...how would I get the query to pick up the value from
the form?
 
Jamie

In the query design mode, in the row of the grid entitled "Criteria", add a
reference to the form's control. It would look something like:

Forms!YourFormName!YourControlName

Note that you are referring to both the form and the control for the value.
Note also that this approach fails if you fail to open the form!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You must log in or register to reply here.

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

Queries Access 2003 use a Drop down box for selection of querycrit 1
Using Combo Boxes as a Source for Parameter Queries 2
Using combo box in a form -- how to make drop-down work? 3
Query with results in a value list from a combo box? 1
Combo Box in a Query 3
Using a combo box as a criteria for a query 1
Using combo box(s) to create a query 1
Query Field Using Other Fields in the Query 3

Back
Top