using lookup values with query prompts

[Ranzi]

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

 

[Jeff Boyce]

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