ACCESS FEED: RE: [MS_AccessPros] Open Form and suspend code until form is closed

Kamis, 25 Agustus 2011

RE: [MS_AccessPros] Open Form and suspend code until form is closed

Chris

Use the acDialog under the WindowMode argument. I might not have spelled things
right, but Intellisense should pop up with a list to choose from.

The dialog mode prevents all other code from running until the form is closed.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com> http://thatlldoit.com
MS Access MVP
<http://mvp.support.microsoft.com/profile/Bill.Mosca>
http://mvp.support.microsoft.com/profile/Bill.Mosca

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Chris Barnes
Sent: Thursday, August 25, 2011 2:22 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Open Form and suspend code until form is closed

How can I open a form from another form's control event and suspend
execution of the event until the opened form closes.

For Example:

Private Sub cmbBox_Click()

Docmd.OpenForm "form"

A bunch of other code

End Sub

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]