Combo Box, query Criteria match

G

GlobalTek

I`m using a form to Generate a report. In My form I have 1 combo box. What
can I put in my Query for the Criteria section if I want the report to
generate the selection i made in the combo box.
 
K

Ken Snell \(MVP\)

If you're using the query grid, put this text (change generic names of
FormName and ComboBoxName to the real names for the form and the combo box):
Forms!FormName!ComboBoxName

If you're using SQL statement:
WHERE YourFieldName = Forms!FormName!ComboBoxName
 
Top