I am using DAO to write new records to a table where the primary key is an AutoNumber type field. After executing the .AddNew, .Update. I would like to retrieve the primary key for the record that was just added. What is the best way to do this? I am working in Access 2007.