Moving Between Main Form and Subform with TAB or Enter Keys

Access help has the following information about navigation between main and sub forms.

[color maroon]To move from the last field in the main form to the first field in the subform, press TAB.

To move from the first field in the subform back to the last field in the main form, press CTRL+SHIFT+TAB.

To move from the last field in the subform to the next field on the main form or to the first field in the next record or next page of the main form, press CTRL+TAB. If the Cycle property of the form is set to Current Record or Current Page, you must use the navigation buttons or other methods provided on the form to move to the next record.[/color]

---------------------------

Although the navigation instructions provided are helpful it is more intuitive to use the TAB key to navigate. Microsoft provided an article explaining how to code a solution that allows users to navigate between form and subform with TAB and Enter keys. The articles contain links to sample downloads.

ACC: How to Move from Subform to Main Form by Using TAB or ENTER
http://support.microsoft.com/support/kb/articles/Q154/8/93.asp

ACC2000: How to Move from Subform to Main Form by Using TAB or ENTER
http://support.microsoft.com/support/kb/articles/Q210/0/11.ASP

ACG Soft provides a more comprehensive solution.

How to control Tabbing and "Enter" key movement in and out of a sub-Form and a Main Form.
http://ourworld.compuserve.com/homepages/attac-cg/AFormTip.htm#KEY