How to make a query ask for criteria?

[hesca]

Hello experts,

To the chase. Is it possible to make a query pop up a dropdown menu so I can chose the value for a specific column?

Heres the specifics:

I have a database for keeping track of customer interactions. So, I have 2 tables:

Table1 named Prospects and
Table2 named interactions.
Table1 contains prospect details such as: name, address, phone, prospect status, etc
Table2 contains documentation of every interaction with the prospects. Fields are: "prospect company name", "date", "details of action taken", "action items" and "due date for action item"

I want to create a query that pops a message for me to choose the "prospect company name" before presenting the data. I want to be able to choose the "prospect company name" from a dropdown, since I have so many, typing them is just inconvenient.

Is this possible? Can I create a query that prompts the user to input a specific column value before running?

[pbaldy]

A query can prompt, but not with a dropdown. For that you'll need to create a form and have the query criteria point there. Note the form has to be open when the query runs; the query won't open it for you.