Previewing Report

[JimP]

I have code that loops through a list of Customers displaying the same
report for each customer in preview mode

1. The problem is that each report overwrites the other and only one
customer's report is displayed
2. Opening the report as "acDialog" solves this problem, but forces the
focus to the report, such that any toolbar buttons to print, etc. are
inactive

Is there a way to loop through each customer's report, and pause to print
etc. before moving to the next customer's report?

 

[Rick Brandt]

I have code that loops through a list of Customers displaying the same
report for each customer in preview mode

1. The problem is that each report overwrites the other and only one
customer's report is displayed
2. Opening the report as "acDialog" solves this problem, but forces
the focus to the report, such that any toolbar buttons to print, etc.
are inactive

Is there a way to loop through each customer's report, and pause to
print etc. before moving to the next customer's report?

I believe you would have to open just the first one from your current code and
then use code in the Close event of the report to launch the next one. Not sure
that would work either though since I've never tried to have a report open
another instance of itself.

Why do you need to pause at each one? Why not just send them one at a time
straight to the printer?

 

[JimP]

...may want to save or send them as a pdf to each customer.

It's interesting that if I use Leban's code code to save each one as a pdf,
that works - but preview doesn't - and I need to give users the option.