Autonumber issue

[benbanyas]

I am using Autonumber with the Increment format for my IDs on a table. I use
a form to enter data into this table. When I go to the next blank form and
begin typing, but then delete the information and close the form, there is
not a record saved in the table but the ID number skips (my last completed
entry is ID 42 but the next one will be 49). How can I get the autonumber
back on track?

 

[schasteen]

Don't use Autonumber. Autonumber will not do what you are looking for. It
only ensures a unique number. If you want sequential numbers, you will have
to write some code to do this.

 

[BruceM]

This link illustrates how to create a number field that increments
automatically without gaps:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb
However, if the user doesn't see the number there may be no harm to gaps.
Access doesn't care.