MS Access Form Events – PT2

This video covers the following MS Access Form Events:

Form_Delete
Form_Unload
Form_Close

Remember:
The Unload Event happens before the Close Event.

Private Sub Form_Close()
    'happens after the unload event
End Sub


Private Sub Form_Delete(Cancel As Integer)
    If MsgBox("Continue with Delete?", vbYesNo) = vbNo Then
        Cancel = True
    End If
End Sub
  
Private Sub Form_Unload(Cancel As Integer)
    If MsgBox("Close Form?", vbYesNo) = vbNo Then
        Cancel = True
    End If
End Sub

<< MS Access Form Events – PT1 | MS Access VBA Control Events – PT1 >>


Leave a Reply