Criteria in a Report

[JPep]

I think I would like to be able to have combobox show on a report. For example, I need to be able to pick criteria from fields of an inventory table and print out the findings. (make=Ford, Model=Explorer, Year=1997, then gives list of all vehicles matching criteria). I know I can get these results form a query, however, the user does not have DB knowledge at all. I would like the user just to be able use the report's combo boxes to select what they are looking for and get back a report of the results. Do I need a report that points to a form? Not sure where to start.<br>
<br>
Thank you for your help!

 

[LWoods]

You can do this with a query that uses the results of a combo box selection in a form as the datasource for a report. (Huh???)<br>
<br>
1. Create a form that shows the car make choices in a combo box.<br>
<br>
2. Create a query that returns the detail records, based upon the output from the form; e.g., forms!formname!comboname.<br>
3. In the 'AfterUpdate' in the form combo box, either (1) open a report that is using the above query as its datasource, or (2) execute a macro that executes the report.<br>
<br>
Follow??? Or, am I off base?<br>
<br>
Larry Woods

 

[JPep]

Thank you - I do follow. I have not had a reason to do this until now. That makes sense to open a report that uses the datasource.<br>

 

[elizabeth]

To make this more foolproof for the user, you'll want to restrict your combo box for year based on Model, model based on year.