Get Access 2000 Next AutoNumber Value

[Michael42]

Hello, upon doing an AddNew using an Access 2000 database and an AutoNumber field how can I extract the new value that it will choose before hand?

I tried the below with mixed results:

'Get\Set Tracking Number
oRS.MoveLast
oRS("Trk_Nbr&quot = oRS("ID&quot
oRS.update

I sometimes get the error below using this code:
Microsoft Cursor Engine error '80040e38'
Row cannot be located for updating. Some values may
have been changed since it was last read.

.../process_forms.asp, line 42


Thanks for your help!

 

[spencertaylor]

Use this query in another recordset

SELECT MAX(ID)
FROM YourTableName

Then put the value it returns in a variable and add one to it.