To run a macro when the Click event occurs, set the OnClick property to the name of the macro.
Remarks
You often use Click macros to carry out the actions for each command button on a form. For example, by clicking one command button on a form, users can print a report showing the form's records. By clicking another, they can open a related form.
You can't use the CancelEvent action in a Click macro to cancel the Click event.