Access 2016 Advanced

Lesson 11 – Using Macros

Access 2016

Steps

Practice Data

2. Press [F4] to open the property sheet. The property sheet for the selected object or control opens .

Press [F4] , if necessary

3. Select the Event tab. The Event tab appears.

Click the Event tab

4. Select the desired Event property. The insertion point appears in the appropriate Event property, and an arrow and a Build button appear to the right of the property.

Click in the On Click property

5. Click the Build button.

Click On Click

The Choose Builder dialog box opens.

6. Select Macro Builder from the list box. Macro Builder is selected.

Click Macro Builder

7. Select OK .

Click

The Choose Builder dialog box closes, and the Macro Tools Design contextual tab opens with the insertion point in the first field in the Action column

Select GoToRecord from the Action drop down list. In the Action Arguments pane, set the arguments for Object Type to Form , Object Name to New Entry , and Record to New . Save and close the Macro Design window. Close the property sheet. Save and close the New Entry form.

Open the New Entry form in Form view and click the Enter New Record button. Close the New Entry form.

A SSIGNING A M ACRO TO A C ONTROL



Discussion

Associate a macro with a control on a form or report using the control’s Event properties. An event is an action, such as a mouse click or a change in value that can initiate a response. The macro runs automatically when the specified event involving that control occurs.

Page 122

OFFICEPRO, Inc.