Assuming you have a primary key, do a .Find (ADO) or .FindFirst (DAO) to find the value of the record you think you just added.

Better would be to set the .Index property of the recordset to "PrimaryKey" and use the .Seek method, cause it's much faster.