VBA Form Object Event Procedures
by admin on Sunday, September 2nd, 2012 | No Comments
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 >>