Printing copies of a report with diferent headers (1 Viewer)

Hi Everyone!

I would like to know if it possible to print three copies of a report but with three diferent headers ( Original, duplicate and triplicate f.i.)and how can I do it
Thanks in advance

What I would do is put all three headers on the same report, then make the labels and fields for two of them not visible. Another shortcut would be to set the tag properties to let you know which labels and such belong to which copy. For example set the tag for all of the first copy to "first", etc.

Print the reports from a form and when the print command button is clicked set a flag for the print and unhide the other headers.

something like

create a public variable in a module.

public strcopy as string

cmdPrint onclick:
strcopy ="first"
docmd.openreport "ReportName", acNormal
strcopy="second"
docmd.openreport "ReportName", acNormal
strcopy="third"
docmd.openreport "ReportName", acNormal


Then in the format event of the report header use the controls collection to hide and unhide the appropriate labels and such.

If you've set the tag properties in advance it becomes fairly simple.

dim ctl as control
for each ctl in me.controls
if ctl.tag=strcopy then
ctl.visible=true
else
ctl.visible=false
end if
next ctl

Let me know if you have any problems with it.

Charity

[This message has been edited by charityg (edited 06-04-2001).]

Thanks for the help but maybe I wasn´t very clear or I couldn´t get it right...
The "body" of the report (all the structure fields and so on) are equal for the three copies. In fact the only thing I would like to change in each copy of the report is a simple word in the header which would be:
- For the first page of the report "Original"
- In the second page (copy ) the word woud be "Duplicate"
- And in the third copy " Triplicate"

Thanks again

Create a Copy of the report with a different name
Change the label to duplicate
can Print it