asked on

Multiple MS Access report instances available for preview

I have a form which provides choices to select how many reports for preview. I use a temp table to store user's choices. Then loop through the choices to try to preview all reports. The code is like the following:
While Not rs2.EOF
Call SetCurrentAENo(rs2!AENo)
DoCmd.OpenReport "rptMedSearch", acViewPreview
rs2.MoveNext
Wend
The problem is I only get the 1st report, no more showing up in screen. If I change DoCmd to DoCmd.OpenReport "rptMedSearch", acViewNormal.
All the reports will be printed out.
However I want to all reports showing up one by one in the screen.
Any ideas?
Really appreciate your help.

Lisa

ASKER CERTIFIED SOLUTION

twalgrave

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

xli2002

ASKER

Because AeNo is dynamically generated, I don't know how many report instances I want each time. From help file, I don't see there is a method to clone a report. Could you please give me more detail help about cloning reports?

twalgrave, your help is greatly appreciated.
Thanks a lot.

Lisa

twalgrave

Sorry about the delay of this response. I didn't get an email notification (EE experiencing some probs)
When I speak of cloning a report in Access, I'm referring to copying the report from access, and pasting it with another name. Hope this helps Lisa.

twalgrave

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
- answered by twalgrave
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

twalgrave
Cleanup Volunteer

SpideyMod

per recommendation

SpideyMod
Community Support Moderator @Experts Exchange