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 ...
Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
