linking query to combo box

  • Thread starter Thread starter Lauren J. Bradford
  • Start date Start date
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
 
Open the query in Design view and in the criteria for State enter:
[Forms]![YourFormName]![YourComboBoxId]
 
Back
Top