Combo Box in a Query Criteria Box

[vstolmech513]

Is there any way to make a criteria box in a query a combo box? I've got a query that shows all information on an individual and right now I've got the expression [Type Last Name Here] in the criteria box, but what I want is to have a combo box that I can choose the individual from rather than having to type the name in. Possible or am I dreaming?

[puppydogbuddy]

Is there any way to make a criteria box in a query a combo box? I've got a query that shows all information on an individual and right now I've got the expression [Type Last Name Here] in the criteria box, but what I want is to have a combo box that I can choose the individual from rather than having to type the name in. Possible or am I dreaming?

How about this:
Create a parameter form containing your combobox, then in your criteria box, replace [Type Last Name Here] with Forms!YourForm! YourCombobox.

In your code, open the form, select the name from the combobox, then execute the query.

[vstolmech513]

How about this:
Create a parameter form containing your combobox, then in your criteria box, replace [Type Last Name Here] with Forms!YourForm! YourCombobox.

In your code, open the form, select the name from the combobox, then execute the query.

Gracias, works great!