Query from combo box

[SicNeMeSiS]

In my database I want to be able to view a report based on a selection in a combo box. I am trying to figure out how to write a query to reference what is selected in the drop down combo box. Any help will be most appreciated. Thank you

Sic

 

[boblarson]

Here's a sample that might help you out. You don't have to modify the query for the report, but you supply the Where clause at the time you open the report:
http://downloads.btabdevelopment.com/Samples/reports/Sample-GenericReport.zip

 

[SicNeMeSiS]

You were right about the WHERE. Thats what I was trying to figure out, how to modify the WHERE to grab the info from the combo box. Been trying to figure out the different access syntax and stuff because im still new access. what i was looking for and found is:

WHERE table.tableName = Form!frmForm1!cboComboBox

Thats what i needed to make my Query work the way i wanted. thank you much for you help and example database.

Sic