Drew Wutka
DWUTKA at marlow.com
Tue May 6 11:04:32 CDT 2003
dim rs as recordset rs.AddNew rs.Field(1).value="Test" rs.Update msgbox rs.Field(0).value rs.close As soon as you update the new record, the Autonumber field is populated. (in my sample code above, the ID/AN is field 0). Drew -----Original Message----- From: Stephen Bond [mailto:stephen at bondsoftware.co.nz] Sent: Monday, May 05, 2003 9:53 PM To: accessd at databaseadvisors.com Subject: [AccessD] New ID/Autonumber value In this thread a couple of months ago there was a solution offered to the problem of determining the value of an ID Autonumber of a record just added. It was stunning in its simplicity, so of course I didn't write it down ;-( Can anyone help? TIA Stephen Bond Otatara, New Zealand ( tel 03 213 1256 fax 03 213 0123 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com