Retrieve the ID of a Newly Inserted Database Record

The ID (counter field) of a newly inserted record is available immediately after the AddNew method executes. Retrieving the ID at this point means you don’t have to mess with the LastModified property and bookmarks. You can clear the variable used to store the ID if you cancel the update. Try this code from a button Click event:

 With Data1.Recordset	.AddNew	MsgBox !ID	.CancelUpdateEnd With
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: