[AccessD] New ID/Autonumber value

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


More information about the AccessD mailing list