Query by selecting from drop down menu

[Jetjefferson]

I have a database which is used to record leads and sales for a saleforce.

Currently, I have a separate query which does the same thing for each person.

What I would like to do is have one query but be able to select which sales person from a drop down.

My Access knowledge is fairly basic and I haven't been able to work out from the help pages how to do this. Is it possible?

All help gratefully accepted

Regards

Derek

 

[neileg]

Use a form. Create a combo box on the form that is linked to a table or query that gives you the people. In your query where you have the name hard coded, replace this with the following criterion:
Forms!MyFormName!MyComboBoxName
Create a button on your form that opens your query or the report based on the query.

 

[PaulJR]

1) Make a form with a drop down menu, where you can select a person.

2) On the query, go to design view, and in the criteria field under the person, right click and select build. Then in the new menu, double click 'forms' to open it, navigate to the form that selects the person (as in step 1), then select the name of the drop down.

When you open the query, it will filter on the person you selected on your form. If you need further help on these steps please just ask