Pull down menu for query

[sweetmikie]

Hi, everyone! So far, your help has been great and has helped me move forward. My next problem is: I have several fields which are combo boxes and I want to be able to do a query to search for each choice. In other words, I have choices A, B, C, D, and E for a combo box. Rather than typing out each one, I want to have a query where a pull-down box will appear, allow me to choose any of these 5 choices, and once chosen, have a "Go" button or some such thing to initiate the query action. Is this possible? Thank you for any help you may provide.

 

[Ranman256]

Use a combo box (cboQuery). The table has 2 fields, 1 for the user caption to pick, and 1 for the query name.
The user sees: Clients registered.
The query is called: qsClientsByNameRagistered.
Then the user clicks the RUN button, it does:

Docmd.openquery cboQuery

 

[sweetmikie]

Is this Visual Basic? I have no idea about Visual Basic or exactly how to input the directions you have given me. I'm an intelligent person, but Access seems so difficult to use. Will you please clarify this for me? Thank you.