Editing existing records

Applies to: Access 2013, Office 2013

To edit existing records, move to the row you want to edit and change the Value property of the fields you want to change. For more information about the Field object's Value property, see Chapter 3: Examining Data. Depending on your cursor type, you will use Update or UpdateBatch to send changes back to the data source. For more information, see Chapter 5: Updating and Persisting Data.

It is usually more efficient to use a stored procedure with a command object to perform updates, as well as to perform other operations, because a stored procedure does not require the creation of a cursor. For more information about cursors, see Chapter 8: Understanding Cursors and Locks.