Same Report Different Footer

E

eb1mom

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
 
O

Ofer

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
 
Top