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
DoCmd.OpenReport "rptMedSearch", acViewPreview
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.
Really appreciate your help.