wrong increments in Autonumber ID.

[Ssstacey]

On one of my forms the ID jumps from 35 to 2534. it is Autonumber and the new values are s'pose to be increments?

Does anybody know why this happens?

Thank u
Stacey

 

[wglmb]

Well if you delete records, the autonumber carries on from where it got to, not from the last existing record. Have you deleted ~2000 records?

 

[Pat Hartman]

Autonumbers can take large jumps like that when you run append queries but cancel the append. The autonumbers are already assigned and so they must be discarded.