How to Get AutoNumber after Insert

  • Thread starter Thread starter XMan
  • Start date Start date
X

XMan

Is there a way to get the generated number for an AutoNumber field after
record is inserted into database? I use the AutoNumber for my table key.
TIA.
 
It depends on how you insert the Record but if you use DAO, check Access VB
Help on the "LastModified" Property.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get PK or autonumber of Newly appended Record 6
Duplicate key on autonumber field! How did this happen? 4
AutoNumber, messed up sequence, duplicate values. 2
AutoNumber versus form record number 2
How create Autonumber field in code? 3
Retrieving the [autonumber] 4
Using an unbound combobox to filter another combobox 1
Duplicating record in mainform, subform and sub-subform 1

Back
Top