linking query to combo box

L

Lauren J. Bradford

I have a query written that searches through my entries by state. On a
separate form, I have created a drop down menu which allows the use to
choose a state. I am having trouble linking the two together. Currently,
regardless of what state is picked in the drop down, all entries appear as
the result of the query.

DoCmd.OpenQuery "State_Query" is what I have so far... what do I need to add
to specify the state.

Thank you for any assistance.

Lauren
 
E

Edward G

Open the query in Design view and in the criteria for State enter:
[Forms]![YourFormName]![YourComboBoxId]
 
Top