Automate the Process

Users would not be happy if they had to click on Refresh each time they select something from the Rating Combo. Fortunately, all Access Objects can be programmed (some assembly required). You can add a little bit of Code to make the Subform Refresh automatically. These are called Events.

 

4. Try it: Find the Event Properties

Go to Home ->Views->View->Form Design.
The Form Design Tools should be available.

 

Select the Rating Combo.

Go to Property Sheet->Event.
 

What Do You See? There are several options for what happens when a User clicks. The Events can occur On Click on On Double (Dbl) Click. Events can also be programmed to run Before or After a Control is Updated.

 

What Makes Sense? In this example, the Subform should Refresh After Update (not before!)  Keep going...

Home ->Views->View->Form Design

Exam 77-885: Microsoft Access 2010

3. Building Forms

3.2. Apply Form Design options: View the Property Sheet