Friday 22 June 2012

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.





No comments:

Post a Comment