8. AddNew without moving to LastModified in VBA

When inserting a new record into a recordset, the new record does not automatically become the current record.

Solution:

To access the new record, move to the bookmark LastModified:

    rst.AddNew
        'Assign fields here.
    rst.Update
    rst.Bookmark = rst.LastModified
    ' Work with the new record here.

---