One Report Format For Independently Executed Reports From Queries

[SeaTigr]

Good day all.



I am developing an inventory database. Presently, I have multiple queries that can be run (system name, serial number, unit type, etc.). Rather than create a report for each query, I'd like to use just one since the same information is reported regardless of query criteria.

Is there a way to customize the report title/label. Instead of a generic label like "Query Report", for example, set up the label to use the name of the query, i.e. set the label to "System Name Query Report" when the System Name Query is executed and "Serial # Query Report" when the Serial # Query is executed?

[RayMilhon]

Yes, as long as the field names are the same. You can set the recordsource, Report Title in the on load event of the report. I've done this previously Using a form for the user to select a specific option in a combo box. Then in the load event of the Report I used a select case statement on what was chosen and set the report title and recordsource to the appropriate query and report name. The only thing you have to watch out for is if the user clicks on the View Report or Print Report (whichever you use to display the report) button before they've acually made a selection in the combo box. I did it by adding a case else and set cancel = true