INSERT INTO Instruction, New Entry: How to create an autooid number?

Question

I have a button click event that takes information from controls and enters it into a table through an INSERT INTO SQL statement in VBA.

I was wondering if there is anything that I could add to this, or any other method to get the record number created for the record?

Can I just turn around and select SELECT against the table and use rs.last?

Answer 1

You can "SELECT @@ IDENTITY" from the same DAO.Database object variable where the INSERT statement was previously run. See here in the Stack Overflow section for more details.