Autonumbers

A

Asif

I have a form with some data being displayed when I go to update the
form an update query runs asking I'm about to update 1 row and I click
yes. The Autonumber (ID field) displayed in this form changes but not
from say 1 to 2 but rather it jumps from 1 to 3. Any ideas why this is
happening?

Thanks
 
J

Jason Lepack

The reason for the jumps is as follows. Create a new record
(Autonumber = 1) If you "dirty" (write something into a field) a form
Access assigns the next Autonumber to that record (Autonumber = 2) and
it's gone. If you cancel that new record and then dirty it you get a
new autonumber (Autonumber = 3).

Cheers,
Jason Lepack
 
Top