Create a command button on a form that runs a query or a macro

1. Open a form in Design view.
   
   
2. Click the Control Wizards tool in the toolbox if it's not already pressed in.
   
   
3. In the toolbox, click the Command Button tool .
   
   
4. On the form, click where you want to place the command button.
   
   
5. In the first wizard dialog box, click Miscellaneous in the Categories box, and then, in the Actions box, click the type of button that you want to create.
   
   
6. Follow the directions in the wizard dialog boxes. In the last dialog box, click Finish to display the command button in Design view.

If you want to see the event procedure that makes the button work, click the Build button in the OnClick property for the command button.