Combo Box, query Criteria match

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default Query Criteria 1
Union Query 1
Expression for Criteria for Form with Combo Boxes 1
Using combo box(s) to create a query 1
query relelated to 2 combo boxes 2
Using form to fill in query criteria not working 2
Multiple search Criteria 5
Need help making query with criteria based on combo box selections 18

Back
Top