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