Printing a report/running the on close macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that opens in preview mode with a macro set to trigger when
the report is closed however if I print the report once it has opened in
preview mode it causes the macro to run. is there a way to stop the macro
running if I am printing the report and not actually closing it?

I am using Access 2003 and have no knowledge of VB.

Thanks in advance
 
Ooops, my mistake. Turns out it was happening as I had set the macro up to
run on a subreport within the report as well. All fixed!
 
Back
Top