Syntax
Private Sub Form_QueryUnload(cancel As Integer, unloadmode As Integer)
Private Sub MDIForm_QueryUnload(cancel As Integer, unloadmode As Integer)
The QueryUnload event syntax has these parts:
e QueryUnload event syntax has these parts:
Part | Description |
cancel | An integer. Setting this argument to any value other than 0 stops the QueryUnload event in all loaded forms and stops the form and application from closing. |
unloadmode | A value or constant indicating the cause of the QueryUnload event, as described in Return Values. |
Return Values
The unloadmode argument returns the following values:
Constant | Value | Description |
vbFormControlMenu | 0 | The user chose the Close command from the Control menu on the form. |
vbFormCode | 1 | The Unload statement is invoked from code. |
vbAppWindows | 2 | The current Microsoft Windows operating environment session is ending. |
vbAppTaskManager | 3 | The Microsoft Windows Task Manager is closing the application. |
vbFormMDIForm | 4 | An MDI child form is closing because the MDI form is closing. |
vbFormOwner | 5 | A form is closing because its owner is closing. |
Example:
Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
If UnloadMode = 0 Then 'X button was clicked
End
End If
End Sub
If UnloadMode = 0 Then 'X button was clicked
End
End If
End Sub
No comments:
Post a Comment