O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Modifying Rows of Recordsets

You can perform CRUD (Create, Read, Update, and Delete) operations on most dynamic Recordsets with VBA code. To test whether a Recordset is editable, check the value of the Updatable property. You can't edit Forward-Only or Snapshot-type Recordsets, and most dynamic queries with INNER or OUTER JOINs aren't editable.

Caution

Don't apply Edit, AddNew, Update, or Delete methods to a Recordset created from the tables of your original Northwind.mdb file. Make a copy of the file in another folder.

Editing and Adding Rows

To edit (update) the current row, apply the Edit method and then set the new value of each field you want to change. The changes don't become permanent until you apply the Update method. Following is the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required