Copy and Rename from Table

[Gerrit.B]

I use several reports, with all the same lay-out.
When changing someting i have to change all reports.

Is it possible to create a "Master" report and using VBA to copy and rename these report to values i have stored in a table.

G.

 

[Joe4]

If they all have the same field names as well as the same format, then you can simply just have one report, and change the Control Source of the report to reflect whatever query or table you wish to pull the data from.

 

[boblarson]

Yeah, as Joe says you can use ONE report but set things how you need or filter actually when opening it.

See here for an example of a "generic" report (I say generic because the same record source is used but it is filtered by different items when opening from different buttons):
http://downloads.btabdevelopment.com/Samples/reports/Sample-GenericReport.zip