Repeat the value from the previous record - Access

Home > Products > Access > Access 2003 Help and How-to > Working with Data > Adding and Modifying Data

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

Repeat the value from the previous record

Applies to: Microsoft Office Access 2003

In a field in a record, you can insert the value that is in the same field in the previous record.

Open a datasheet (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 a form in Form view (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.).
Click in the field in which you want to insert the value.
Press CTRL+APOSTROPHE (').