Prev: Creating a Menu
Next: Resolved
From: kenrav on 8 May 2010 00:23
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?
From: Stuart McCall on 8 May 2010 07:29
"kenrav" <kenrav(a)discussions.microsoft.com> wrote in message
news:37F6FFD6-454E-41E3-A541-B64EEC65B0F8(a)microsoft.com...
>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.


 | 
Pages: 1
Prev: Creating a Menu
Next: Resolved