Combo Box, query Criteria match

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

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
query based on combo box on form not working. Coming back blank 1
Using form to fill in query criteria not working 2
Using combo box(s) to create a query 1
Union Query 1
Find record in a table using combo box. 3
Access is compiling query results rather than creating a new set 10
Combo Box in a Query 3

Top