If you add a new field between two existing fields, Access recognizes the new field and places it as the last tab stop in the form.

Question

Quizplus · Accepted Answer

When a new field is added between two existing fields in a form, Access recognizes the new field and automatically places it as the last tab stop. This means that users can easily navigate to the new field by pressing the Tab key, without having to manually update the tab order.

If You Add a New Field Between Two Existing Fields