Assigning a Macro to a Button

Database designers often attach macros to form controls, particularly buttons, so that when a user clicks the button, the macro is activated. If you create a button, you can use the Command Button Wizard to specify the action that will occur when the button is clicked. If you want to assign a macro to a button, you choose the action of running the macro.

Assign a Macro to a Button

In Design view for a form, click the Command Button tool on the Toolbox.

Click the Control Wizards button on the Toolbox.

Drag the image onto the form, report, or page.

Click Miscellaneous.

Click Run Macro and then click Next.

Choose the macro you want to run, and then click Next.

Specify the text or image that will appear on the button, and then click Next.

Enter a name for the command button control, and then click Finish.

Save the form or report, and then test the button to verify that your macro runs when the button is clicked.