Hi,
I'm trying to use the AddNew method of ADO recordset object. In my table I have an Identity(Auto number) field which I need to access before updating as another field is a string format of the same number. My recordset properties are:
CursorLocation = adUseClient
Cursor Type = adOpenDynamic
Locktype = adLockOptimistic
Other details
DB - SQL Server 7.0
ADO 2.1

I'm unable to access the Identity field even after the update.
With DAO Addnew method I can access the Auto number field as soon as I say AddNew.


Any help is appreciated
Thanks
Poornima