Null value in AUTONUMBER field after MyRS.RECSET.AddNew
Hi,
If you are using Access 2000, then you can get new
links to see how to do that
http://www.able-consulting.com/ADO_Faq.htm#Q9
http://support.microsoft.com/directory/article.asp?
ID=KB;EN-US;Q195910&LN=EN-US&SD=msdn&FR=0&qry=HOWTO%20work%
20with%20autonumber%20in%
20ADO&rnk=1&src=DHCS_MSPSS_msdn_SRCH&SPR=MSALL
Val
Quote:
>-----Original Message-----
>How can I receive AUTONUMBER value from MDB table
>immediate after MyRS.RECSET.AddNew
>command. In MS SQL following code works correctly:
>
>With MyRS.RecSet
> .AddNew
> .Update
> Debug.Print ![MenuTreeID]
>End With
>But for MDB table Debug.Print ![MenuTreeID] returns 0.
>.
