Same Report Different Footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top