I'm INSERTing a record into an Access database that uses the AutoNumber datatype for its primary key field. Table definition is as follows:

Table: RefHdr
Fields: RefHdrKey AutoNumber
AuthNo Char(13)
Comment Char(30)

I do a: INSERT INTO RefHdr (AuthNo,Comment) VALUES ('3001','Referred to Dr. X')

After doing the INSERT, how can I determine what Access assigned to the RefHdrKey field value, baring in mind that this is a multi-user system with new records being added every few seconds?

Thanks In Advance.

Jon