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 >>

Get all the videos in this Access VBA collection 100% FREE by signing up at http://vbahowto.com/ms-access-tutorial