Navigate Form Sections and Set Focus on First Field of First Record in a Subform in Microsoft Access

In this Microsoft Access tutorial, you will learn how to navigate form sections and set focus on the first field of the first record in a subform. We'll address a common issue where the tab order skips the header section, providing both beginner keyboard shortcut solutions and a simple programming method using VBA to customize form navigation.

Antonio from Lytle, Texas (a Gold Member) asks: I have created a parent form that includes a subform. The subform contains fields in both its header and detail sections. When I tab from the parent form to the subform, it skips the header and directly navigates to the detail section of the subform. I'd like the tab order to be: Parent Form, Subform Header, and then Subform Detail. Can anyone help me achieve this?

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

UP NEXT:

RECOMMENDED COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Microsoft Access subform navigation, Access set focus first field, Access subform header tab order, VBA go to record, Access subform tab solution, Access parent form navigation, Access F6 keyboard shortcut, Access on enter event, Access beginner form navigation tutorial

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[Shadow.Dragon]

I'm looking forward to this series. I have a similar situation that I may be able to use these techniques! Thanks Richard!

[stephenbeswick]

Very good video hi Richard I have a user every time he opens the database on a customers booking system he gets an error have you got any ideas what it could be. Great video. Steveb

[rbhnr]

From about 3:30 to 4:00, you are talking about moving between fields, but your video is not refreshing to show the same actions. I have seen this issue once before on another of your videos.

[xavierbatlle]

I changed all my docmd.gotocontrol commands with control.setfocus many years ago. 😂