- To create a macro, click Macros
under Objects, and then click the New button on the Database window toolbar. - In a blank action row, click SetValue in the action list.
- Set the Item argument to the identifier for the property whose value you want to set, and then set the Expression argument to the value you want to assign to the property.
- Click Save
to save the macro. - Go to the form or report, open the property sheet for the object whose event will run the macro, and set the event property to the name of the macro.
Use Visual Basic code- To open the event procedure for the appropriate event, open the form in Design view.
- Display the property sheet for the form and then click the Event tab.
- Click the event property for the event that you want to trigger the procedure.
For example, to respond to a mouse click on a command button, open the button's OnClick event procedure.
- Click Build
next to the property box to display the Choose Builder dialog box. - Double-click Code Builder to display the event procedure window
- Add an assignment statement to the procedure by typing the identifier for the property whose value you want to set, an equal sign (=), and the value you want to assign.
- Do one of the following:
To refer to the property of a control on the current form, type the Me keyword followed by the ! operator, the name of the control, the . (dot) operator, and the name of the property. For example, the following statement assigns the value False to the Visible property of the DateDue control on the current form:
Me![DateDue].Visible = FalseTo refer to the property of a control on a different form, type the control's full identifier. For example, the following identifier refers to the Visible property of the DateDue control on the ShipForm form:
Forms![ShipForm]![DateDue].Visible