Previewing a report

  • Thread starter Thread starter Jim Pockmire
  • Start date Start date
J

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?
 
Jim said:
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?
Click to expand...

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.
 
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)
 
Back
Top