Bill,
I have once again encountered that when I use the Close button on the Sold form (when the control was last in a subform), if the subform's AfterUpdate event results in a message reminding the user that they might need to add certain info, the close event for the main form still closes anyways.
Therefore I was wondering if there was another way around this problem. Perhaps looking to see if the msgbox was open.
Now I'm wondering if it would work to set a variable before the subform's opening of the msgbox and when I click on the Close button on the main form have it first check to see if the variable is true and if so exit sub.
Would that work?
Connie
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Connie -
>
> MsgBoxes are always modal. You can't do anything when they are open and your code pauses until the user responds.
>
> Therefore, you can't test to see if any are open. You're stuck at a standstill until the box is closed.
>
> Can you give us a reason as to why you would want to do this?
>
> Bill Mosca
>
> --- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@> wrote:
> >
> > Good afternoon/evening! Is there a way to test if any message boxes are open?
> >
> > thanks!
> > Connie
> >
>
Tidak ada komentar:
Posting Komentar