Same Report Different Footer

[Guest]

Is it possible to print same report information with a different footer?
Three copies of same report, with "for the boss", "for supervisor", or "for
employee" in the footer. thanks

 

[Guest]

Run the code to print the reports using the open args
docmd.OpenReport "ReportName",,,,,"for the boss"
docmd.OpenReport "ReportName",,,,,"for supervisor"
docmd.OpenReport "ReportName",,,,,"for employee"

Now on the create a field, on the "on print" event of the footer, write the
code
me.FieldCreatedName = me.OpenArgs

that will assign the value to the field created

 

[Guest]

Thanks, report now prints the way it needs to.

 

[Guest]

Any time, have a good weekend

Thanks, report now prints the way it needs to.