[AccessD] New ID/Autonumber value

Sorry to disagree Drew but I think it's

rs.AddNew
rs!Myfield="Test"
etc
etc
rs.Update
rs.bookmark=rs.lastmodified
msgbox rs!MyAutoNumber
rs.close

I think you have to do the .bookmark line. Without that you're not on
the right record


Andy Lacey
http://www.minstersystems.co.uk





> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
> Sent: 06 May 2003 17:05
> 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/a> ccessd
> Website: 
> http://www.databaseadvisors.com 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
>