VBA Form Object Event Procedures

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

Offsite Related Information:

“Go Fund Me” Page

($5 suggested amount)

(…10% of your gift amount will go to charity)

Free! Subscribe To Our YouTube Channel!

Free MS Access VBA Programming Course

Facebooktwitterredditpinterestlinkedinmailby feather