• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

16. Programming DAO: Data Manipulation L... > 16.5. Editing Data Using a Recordset

Editing Data Using a Recordset

Let us now discuss the methods used to edit, add, or delete data from a table-type or dynaset-type recordset. Snapshot-type recordsets are static, so data in such a recordset cannot be changed. Thus, in this section, the term recordset will refer to table-type or dynaset-type recordsets. Recall that any changes made to a recordset are reflected in the underlying tables or queries.

Editing an Existing Record

Editing an existing record is done in four steps:

  1. Make the record the current record.

  2. Invoke the Edit method for the recordset.

  3. Make the desired changes to the record.

  4. Invoke the Update method for the recordset.

It is important to note that if you move the current record pointer before invoking the Update method, any changes to the record will be lost.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint