Add New Record (ADO)

Please Help,

I am adding a new record to a recordset and then using the update method to commit the record. The problem is getting the recordset to point to the record which was added. How do I move to this record after issueing the update command.

Thanks for any help

Chris

You could probably use a bookmark, or you can store the Primary Key field, update, then query again for the same primary key field. That won't work if your primary key is an autonumber and you are adding the record though...