Question about a Modal form

[Jim Evans]

If I open a from that is specified as Modal, from VBA, an I assured that the
next line of code will not execute until the opened form is closed?

Jim

 

[Tom van Stiphout]

On Tue, 15 Dec 2009 08:20:29 -0500, "Jim Evans"

No. That behavior comes with setting the WindowMode to acDialog in
your DoCmd.OpenForm line.
The Modal property of the Form object just prevents you from selecting
a different form.

-Tom.
Microsoft Access MVP

 

[Jim Evans]

Thanks, Tom. I will change the WindowMode.

Jim

On Tue, 15 Dec 2009 08:20:29 -0500, "Jim Evans"

No. That behavior comes with setting the WindowMode to acDialog in
your DoCmd.OpenForm line.
The Modal property of the Form object just prevents you from selecting
a different form.

-Tom.
Microsoft Access MVP