[AccessD] New ID/Autonumber value

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


More information about the AccessD mailing list