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.
 
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
 
Back
Top