acDialog

[Steve]

I have the following code which opens a Password form. I <thought> that
because of the "acDialog", the code will stop or pause until the
Password Form is closed. However, the MsgBox for Response (which is
there for my debugging purposes) displays as soon as the Password form
opens. Am I doing something wrong?

Sub BxProtect_BeforeUpdate(Cancel As Integer)
'6.24.05
Response = 0
If Not [BxProtect] Then
DoCmd.OpenForm "Password", , , , , acDialog
End If
MsgBox "Response = " & Response
End Sub



Thanks

Steve

 

[Steve]

Solved my problem. Set Password form to "modal"

 

[Rick Brandt]

Solved my problem. Set Password form to "modal"

Shouldn't have been necessary. The acDialog option makes the form modal
automatically.

 

[Albert D.Kallal]

Solved my problem. Set Password form to "modal"

Model forms do not halt code. acDialog forms do.

There is a VERY big difference between the two types of forms.

You can read about them here:

http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html