Printing several reports from a form

[Bo Gustafsson]

He

I want to print 3 reports after each other from a form i Ms Access XP.
I also want to set the last pagenumber from report1 in report2 .
The problem is when report1 is printed and I start printing report2 it newer
vill be printed
nothing seems to happen.

I have try to do this by start printing report 2 from the event
report1_Close
Private Sub Report1_Close()
DoCmd.OpenReport "Report2", acViewNormal
End Sub

I have also try to go back to my form and start printing report2
Public Sub Print_report2()
MsgBox "Print startad"
If Me!Utskriftsmedia = 1 Then
MsgBox "Print1startad"
DoCmd.OpenReport "Report2", acViewPreview
Else
MsgBox "Print2 startad"
DoCmd.OpenReport "Report2", acViewNormal
MsgBox "Print3 startad"
End If
End Sub

The statement "Print startad" and "Print2 startad" is executed
The statement "Print3 startad" is not executed and report2 is not printed
and nothing seems to happen.



Any help or suggestions is greatly appreciated.
Bo Gustafsson

 

[Fons Ponsioen]

A possibility could be to make the reports subreports of a
blank main report, this would also resolve the pagenumber
issue.
Hope this helps.
Fons

 

[Bo Gustafsson]

No I want to print 3 main report and
the problem is when report1 is printed and I start
printing report2 nothing seems to happen and report2 is newer printed.
//Bo