Serial coding

K

kenrav

I have some code that opens a report and then displays a msgbox.
Unfortunately, the report opens and then the msgbox opens on top of it. Is
there a way to code it so that the msgbox doesn't open until after the report
is closed?
 
S

Stuart McCall

kenrav said:
I have some code that opens a report and then displays a msgbox.
Unfortunately, the report opens and then the msgbox opens on top of it.
Is
there a way to code it so that the msgbox doesn't open until after the
report
is closed?

If using A2003 or later, specify acDialog in the OpenReport's windowmode
parameter. This prevents any code from executing while the report is open.

Or you could open the msgbox in the report's close event.
 

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

Top