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.