I have a form that jumps from Tab Index 25 to Tab Index 33 even though there are controls with Tab Index 26, 27, etc. Tab Stop is set to Yes for the skipped controls.
Perhaps you could post a copy of your database in zip format.
Do you have any event procedures related to the form and/or controls that could interfere/direct tab order?
We need more info to suggest "probable cause" etc.