Add an After Update Event

You can also use the Property Sheet to add an After Update Event to automatically Refresh the records in the Subform when a User selects a Genre from the Combo Box.

 

The Rating Combo has an Embedded Macro as an After Update Event. The Genre Combo will have an Event Procedure in Visual Basic.

 

This example will be a simple introduction to the programming behind Microsoft Access. We will explore Microsoft Visual Basic for Applications (VBA) more in the next lesson.

 

4. Try it: Add an After Update Event

Select the Genre Combo Box Control.

Go to Property Sheet->Event.

Click on After Update.

Select: Event Procedure.

 

Click on the 3-Dot Builder.

 

Keep going, please.

Exam 77-885: Microsoft Access 2010

3. Building Forms

3.2. Apply Form Design options: View Code

Form Design Tools->Design->Tools->Property Sheet