Create a command button that updates form data

Create a command button that updates form data

If you're using a database that's shared on a network, you can view the latest version of existing records by creating a command button that updates form data. If you want to display all the updated records, including new ones, you can requery the records. For more information about requerying records, click .

  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 Command Button control.

  4. On the form, click where you want to place the command button.

  5. In the first wizard dialog box, click Form Operations 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.