Undo changes

1. Click the arrow next to Undo .

   Microsoft Access displays a list of the 20 most recent actions you can undo.

2. Click the action you want to undo.

   When you undo an action, you also undo all actions above it in the list.

Notes

• If you later decide you didn't want to undo an action, click Redo .
• In a Microsoft Access project, you can't undo changes in table Design view or in a database diagram.
• Access clears the Undo list when you switch to another view from Design view of a data access page, a table in an Access database, or to a view, stored procedure, or function in an Access project. If you are working in Design view of a form that contains a subform and you switch to Form or Datasheet view or open the subform in its own window, Access removes from the list any recent actions that apply to the subform. Also, if you are working in Design view of a report that contains a subreport and you switch to Print Preview, Access removes from the list any recent actions that apply to the subreport.

• Do one of the following:
• Click Undo on the Table Datasheet, Query Datasheet, or Form View toolbar to take back your most recent change.
• Click Undo Saved Record on the Edit menu if you have already saved changes to the current record, or have moved to another record.

As soon as you begin editing another record, apply or remove a filter, or switch to another window, you can't use these methods for correcting changes.

• Click Undo on the record navigation toolbar.

Note  If you don't see the Undo button or if it appears disabled, it means one of the following:

• The designer of the page has customized the button. Look for custom instructions on the page on how to undo your changes.
• The page is read-only and does not support additions or edits.

You can discard any changes— including changes to Microsoft Visual Basic code— that you have made in Design view of a form or report and revert to the last saved version of the form or report.

Caution  Once you have reverted to the last saved version of the form or report, you cannot recover the changes that you have made to the form or report since you last opened it.

• To revert to the last saved version, on the File menu, click Revert.

Note  This command is not available unless you have opened a form or report in Design view and have made changes to it. The Revert command is not available in Design view of a data access page.