Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Microsoft: Access Forms FAQ

Form Basics

Moving Between Main Form and Subform with TAB or Enter Keys by tlbroadbent
Posted: 30 Aug 01

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

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.


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

ACC2000: How to Move from Subform to Main Form by Using TAB or ENTER

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.

Back to Microsoft: Access Forms FAQ Index
Back to Microsoft: Access Forms Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close