devxlogo

Retrieve the ID of a Newly Inserted Database Record

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

devx-admin

Share the Post: