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 (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.), you can't undo changes in table Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.) or in a database diagram.
• Access clears the Undo list when you switch to another view from Design view of a data access page (data access page: A Web page, published from Access, that has a connection to a database. In a data access page, you can view, add to, edit, and manipulate the data stored in the database. A page can also include data from other sources, such as Excel.), 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 (Form view: A window that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.) or Datasheet view (Datasheet view: A window that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.) 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 (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.) 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 (data access page: A Web page, published from Access, that has a connection to a database. In a data access page, you can view, add to, edit, and manipulate the data stored in the database. A page can also include data from other sources, such as Excel.).