I create a new recordset object and open it. I then loop through a record from the database and using the new object create a new record that is a copy of the old except for the identity field which self increments when i to the obj.update . Is there any way for me to get the new value in this field. I looped through the object and that fields value is empty. I could rewrite it as a sql statement and use the "SELECT @@IDENTITY AS NewID" and the objconn.execute(sql).nextrecordset to get the value but I was hoping there was a way to do it using the recordset object.