Print two copies but each with different footer text?

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

Guest

I have a report representing a form that needs to have 2 copies automatically
printed for distribution. The only difference between the two copies is the
text at the end of the page. One need to read "Purchaser Copy" the other
needs to read "Originator Copy".

Anyone know an easy way to do this? Using a single button maybe?
 
Try sending a different OpenArgs in the Report open command line
docmd.OpenReport "ReportName",,,,,"Purchaser Copy"
Or
docmd.OpenReport "ReportName",,,,,"Originator Copy"

On the On format event of the footer write
Me.FieldName = Me.OpenArgs
 
Tec92407 said:
I have a report representing a form that needs to have 2 copies
automatically
printed for distribution. The only difference between the two copies is
the
text at the end of the page. One need to read "Purchaser Copy" the other
needs to read "Originator Copy".

Anyone know an easy way to do this? Using a single button maybe?
Click to expand...

You can't do it with the "Number of copies" or similar button in the Print
dialog -- that is for printing identical copies.

Code behind a single Button can open two different Reports. You will need to
use some VBA as the CommandButton Wizard will only generate the first
DoCmd.OpenReport...

Ofer has already suggested how you pass the two different text phrasess.

Larry Linson
Microsoft Access MVP
 
Back
Top