I have built a form which updates tables in an Access database using the AddNew method. The table contains an autonumber field which I display after the table has been updated. My problem is that most of the time, the correct autonumber will be returned. But sometimes it gets stuck on the same number and, although the table is updated, the same number is displayed over and over. Here is a sample of my code. Have you run into this before and can you help?<BR>rsRequest.Open "RequestInfo", strConnect, adOpenForwardOnly, adLockOptimistic, adCmdTable<BR>rsRequest.AddNew<BR>---fields added to table from the form<BR>rsRequest.Update<BR>varbookmark = rsRequest.absolutePosition<BR>rsRequest.Requery<BR >rsRequest.absolutePosition = varBookmark<BR>&#060;% Response.Write rsRequest("RequestNumber")%&#062;<BR>---RequestNumber is the autonumber field