MS Access Form Events – PT1

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

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

Also we will look at controlling the Form_Load with a public variable and the Form_Current event.

The possibilities for the Form_Current event procedure.
-diplay a message box
-display data in the caption of the form.
-display the customer’s previous order
-display all the books by the publisher (based on publisher id)
-perform form level calculation on form data

The Current Event happens before the Load Event.


<< VBA Form Object Event Procedures | MS Access Form Events – PT2 >>

Get all the videos in this Access VBA collection 100% FREE by signing up at

facebooktwittergoogle_plusredditpinterestlinkedinmailby feather
Tags: , , , , , ,
Previous Post

MS Access VBA Control Events – PT1

Next Post

MS Access Form Events – PT2

Leave a Reply