Open the form in Design view by right-clicking the form in the Navigation Pane, and then clicking Design View on the shortcut menu.

If you have already created and saved a macro, you can easily create a command button that runs the macro by dragging the macro from the Navigation Pane to a form that is open in Design view. Top of Page Create a button by dragging a macro to a form The Macro Builder is displayed, showing the action or actions that make up the embedded macro. Click anywhere in the property box, and then click in the right side of the box. On the Event tab of the property sheet, should be displayed in the On Click property box. In the Navigation Pane, right-click the form that contains the command button, and then click Design View or Layout View on the shortcut menu.Ĭlick the command button to select it, and then press F4 to display its property sheet. View or edit a macro embedded in a command button The macro contains actions that perform the task you chose in the wizard. The wizard creates the command button and embeds a macro in the button's On Click property. In the design grid, click where you want the command button to be inserted.įollow the directions in the wizard. On the Design tab, in the Controls group, click Button. On the Design tab, in the Controls group, ensure that Use Control Wizards is selected. Right-click the form in the Navigation Pane, and then click Design view on the shortcut menu. What do you want to do?Īdd a command button to a form by using a wizardĬreate a button by dragging a macro to a formĬreate a command button without using a wizardīy using the Command Button Wizard, you can quickly create command buttons that do a variety of tasks, such as closing the form, opening a report, finding a record, or running a macro. This makes it possible to copy the command button to other forms without losing the functionality of the button. You can also embed a macro directly into the On Click property of the command button. To make a command button perform an action, you write a macro or event procedure and attach it to the command button's On Click property. For example, you can create a command button that opens another form. You use a command button on an Access form to start an action or a set of actions.

Access 2016 tabular layout