Query from a Combo Box Selection?

[bkvisler]

This may be simple but i'm a newbie. How do you tell access to run a query based on a section a user has made from a dropdown menu? For example, i want users to be able to pick a name from a dropdown menu and have access bring up all records that include that name. Thanks in advance for the help.

[ConneXionLost]

In the query design, add a criteria where the name must equal the value of the combo box on the form.

[bkvisler]

I understand what you are saying to do, however i dont know exactly what to type in the criteria line. Could you please be a little more specific. Please forgive my ignorance.

[ajetrumpet]

i want users to be able to pick a name from a dropdown menu and have access bring up all records that include that name.

SELECT * FROM TABLE WHERE [NAME]=FORMS![name of your form here]![name of your combo here]