Printing a report/running the on close macro

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
 
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

keeping queries behind a report from opening 3
Access Access Report Works on One Machine but not Another 3
Open up report in print preview from macro but showing 2 pages??? 3
Report Printing 1
Printing a report 2
Print Preview Close 2
Previewing a report 3
PrintOut Macro 2

Top