Previewing a report

[Jim Pockmire]

I have code that loops through some statements, previewing the same report
each time through. After the first report previews and I close it, the loop
seems to end and will not prewiew the remaining pages. It seems as if I need
to be trapping some event or somewhere within the code to pause it. Any
ideas?

 

[Rick Brandt]

I have code that loops through some statements, previewing the same
report each time through. After the first report previews and I close
it, the loop seems to end and will not prewiew the remaining pages.
It seems as if I need to be trapping some event or somewhere within
the code to pause it. Any ideas?

Are you also closing the report in the loop? Unlike a form, a report that is
already opened will not be refreshed if you issue another Open method on it. It
will just continue to display what was already there.

 

[Jim Pockmire]

I was not closing the report in the loop, only on the toolbar. I am guessing
that I need to do this with a DoCmd.Close (object)