In this video I talk about how to program vba object items like
the access form .

Specifically we look at the Access Form Open Event, and add a password prompt in the open event of the form.

Also we will look at controlling the Cancel Open Event of the form.

Private Sub Form_Open(Cancel As Integer)
'    MsgBox "form opened"
    
    Dim strPassword As String
    
    strPassword = InputBox("Enter The Password")
    
    If strPassword <> "Password" Then
        MsgBox "Incorrect Password"
        Cancel = True
    End If
    
    
End Sub

<< VBA Event Driven Programming | MS Access Form Events – PT1 >>