Access 2016 Advanced
Access 2016
Lesson 11 – Using Macros
Steps
Practice Data
4. Select the desired property.
Click in the On Got Focus property
The insertion point appears in the appropriate property and an arrow and a Build button appear to the right of the property.
5. Select the property list.
Click On Got Focus
A list of events for the property appears.
6. Select the desired macro.
Click Limit
The selected macro appears in the property.
7. Press [F4] to close the property sheet. The property sheet closes.
Press [F4]
Close the Customers form and save the changes. Open the Customers form in Form view and click the Credit Limit field. Notice that a message box generated by an existing macro opens. Select OK to close the message box. Close the form window.
C REATING A C OMMAND B UTTON
Discussion
Command buttons are controls to which you can assign actions. They are often used to run macros in a form or report. Place descriptive text or a picture on a command button so that user’s can easily identify the button’s purpose.
Create a command button in Design view. On the Design tab in the Controls group the Button button. After you create the command button on the form, set the properties, such as the event property to initiate the action and the text or picture to appear on the button.
OFFICEPRO, Inc.
Page 125
Made with FlippingBook - Online magazine maker