Missing autonumbes? Where did they go? What the ?

[Guest_imported]

I have a main form that is based directly on my main table. I have an autonumbering system for each record (starting at 1). I also have a subform where employee names are entered. From this subform, if I enter a name that is not in the combobox, an employee form pops up that allows me to enter in a new employee (this form is also based on its own table that has an autonumber system to number employees)

I went into my main table to look at something and noticed that there is a drastic jump from autonumber#38 to #60 with no blank records in between. After I had entered record #38, (now hopping to record #60 without my knowledge) I also entered several new employee records. There was also a dramatic jump in the autonumber sequence (from #92 - 161 !) in this table. There are no missing records and all of the right info is associated with the main records.

I understand that you will generally lose an autonumber if you delete a record (it will skip a number in other words) but that is not the case here.

What happened to the my numbers? Why did Access decide to jump its autonumber sequence?

As a side note: In or around the time that this happened, I performed a database split where the tables are removed from the present database and put into a backend database. I don't know if this matters but ...