ENTER criteria (in query) when running a report 1

[chris3942]

I run reports based on a table. I use a query to present the appropriate data when the user chooses to run the report. The report has a column titled "Manufacturer" which corresponds to a column in the table the report data is based on. In the query the criteria for the Manufacturer column contains: [Enter Manufacturer]. When the user runs the report a window prompts the user to enter the "Manufacturer". I would like to present a list to user to to allow him/her to select the appropriate "Manufacturer" to satisfy the query.

 

[THWatson]

chris3942
Create a form with either a list box or a combo box that shows your Manufacturers. Then have a command button to run the report.

In your query that populates the report, in the Manufacturers column, put the following criteria
Forms!YourInputFormName!ListBoxName.Column(x)

(another method would be to remove the criteria from the query column and include a Where condition in the code that calls for the report to be printed. Something like...
DoCmd.OpenReport "YourReport, acViewNormal,,WHERE condition)

I don't know enough about your table setup to indicate what the Where condition might be.

Hope this helps.

Tom

 

[chris3942]

Thanks for the tip Tom. The code worked well.