View Single Post
  #1 (permalink)  
Old May 10th, 2005, 02:54 PM
mrslockdown2003 mrslockdown2003 is offline
Registered User
Join Date: May 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Create Sequential Numbering That Does not Skip

I am trying to create a field that will automatically generate a sequential number (one that will not skip integers!). I would like to use little code if at all possible. Autonumber in Access does not work for what I am trying to do. For example... I have a record #1 then I want the next record to be #2, however if I hit escape within the new record (#2), the next number generated is #3. I need it to always be in sync. Any suggestions?

Reply With Quote