Check this post on the same subject
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public
.access.formscoding&mid=32c2379f-8361-4fe4-9fa7-ef39f41768aa

Signature
Good Luck
BS"D
> After i execute rs.Addnew....rs.Update how do I get the autonumber key that
> was added?