Opening multiple reports in print preview (1 Viewer)

[MarkE]

New guy but immediatly my first question. I use Access 2007.

So I have a few reports (let's call them X, Y and Z). I want, after a user clicks a button, X, Y and Z open after eachother. So the first report to see is X. When they click the buttons on the bottom of the page ( the > button ) they go to report Y, and after that, you guessed it, report Z.

Just doing DoCmd.OpenReport "ReportName", acViewPreview three times in a row does not work, it only shows report Z then.
Adding Y and Z as subReport of X also doesn't work because the lay-out of the document would be completly messed up.

Help is really appreciated, making a fool of myself at the office now haha... Thanks!

 

[llkhoutx]

The report are opened and stacked (overlaid) with the next report. Execute the docmd.openreports in the reverse order, such that X is the last opened, etc. The last opened will be on top of the stack,

 

[MarkE]

Thank you for the quick response. When I do this, they only show the last one opened. Do you have any idea how to fix this?

 

[llkhoutx]

The reports must be maximized with the last one on top.

Why do you need them all opened at the same time?

On each report's Report_Open even, move each report to a screen position and size you think appropriate, e.g. me.movesize per the method shown here.

 

[MarkE]

Well, the other reports are most of the times used in combination with the first one. Let me explain better:

Page 1 has to be report X, page 2 has to be report Y and page 3 has to be report Z. I'm not getting anywhere now... Really appreciate the help. Thanks!

 

[llkhoutx]

But why do they all have to be open in "preview" mode at the same time? Just open them, is really necessary.

If a report is on another report, it's a subreport. What your saying doesn't make sense to me.

I missed the acViewPrevoiew in your first post.