using lookup values with query prompts

  • Thread starter Thread starter Ranzi
  • Start date Start date
R

Ranzi

query parameter... can the prompt supply the drop down options; my users do
not know all of the possible valid values when prompted.
 
Ranzi

Queries are not designed for (and don't have) a drop-down capability.

If you want to provide your users a list of valid values, use a form. Then,
in your query, 'point' to the form's combobox, using something like:

Forms!YourForm!cboYourCombobox

as the selection criterion for that field.

You'll need to add a command button to the form to have the users <Run
Query>, and the form will have to be open (and a combobox item selected) for
the query to work.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top