Stephen Bond
stephen at bondsoftware.co.nz
Tue May 6 16:00:59 CDT 2003
Drew, that's the one! Have written it down this time. Many thanks Stephen Bond -----Original Message----- From: Drew Wutka [mailto:DWUTKA at marlow.com] Sent: Wednesday, 7 May 2003 4:05 a.m. To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] New ID/Autonumber value 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com