You can make it easier for users to update records by adding an Undo button to a form. The Undo button will allow them to cancel changes made to a record without having to go back and retype or delete entries made to a field. Follow these steps to add an Undo button to a form:

  1. Open the form in Design view.
  2. Right-click any toolbar and click Toolbox. Click to activate the Control Wizards button, if necessary, and then click the Command button tool. (In Word 2007, in the Form Design Tools tab, click to activate the Use Control Wizards button in the Controls group, if necessary, and click the Command button.
  3. Click and drag in the form where you want to locate the command button.
  4. Under Categories, click Record Operations.
  5. Under Actions, click Undo Record.
  1. Click Next.
  2. Click Next.
  3. Enter cmdUndoRecord.
  4. Click Finish.

Miss an Access tip?

Check out the Microsoft Access archive and catch up on other Access tips.
Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.