Ask for Parameter using a look-up field

[Jorlypong]

I set up my query to ask for a parameter in a pop up msgbox but is there a
way rather than typing in the value it provides a drop down list to choose
the value from a look-up field.

I understand I can set up a seperate form and have the query critera look
for that value but it would be great to cut out the step of opening the form
before my query. I wouldn't mind doing it that way if I knew how to have the
query automatically open the form (make the form act as my parameter msgbox).
Any help would be great.

 

[Jeff Boyce]

Queries don't have drop-down boxes; forms do.

The standard approach is to use the form anyway. Opening/running the query
puts the user "behind the curtain". Using a form and letting the user
select from a listbox/combobox, then click on a command button makes using
the application a bit friendlier...

Regards

Jeff Boyce
Microsoft Office/Access MVP