Look Up in Query Prompt

  • Thread starter Thread starter Suzanne
  • Start date Start date
S

Suzanne

I have a table tracking marketing campaigns and I am
developing a query to pull information for one specific
campaign. I added a prompt to the criteria section under
the campaign field in my query but I would like for the
prompt to offer the drop down menu (look up) that is
provided in the original table so the end-user can select
from a list and won't have to type the name in -- since
they may not know the exact phrasing of the campagin name.

However I can't seem to figure out how to make the prompt
on my query a lookup list (drop down menu).

Any ideas?

Thanks so much for the help!
Suzanne
 
You can't make any modifications to the built-in parameter query prompt.
You will have to create an unbound form with a combo box and use a
reference to the combobox on that form as the criteria of your query. The
general syntax would be like this:

Forms!YourFormName!YourComboBoxName

Add a command button to the form to actually call the query.
 
Back
Top