Results 1 to 2 of 2
  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    316

    Navigate to Subform from Main Form when Enter Key is Pressed

    I have a Main/Sub Form combination. When the operator opens the Main Form, she hits Enter to navigate through the fields. When she gets to the last field on the Main Form and hits Enter one more time, control passes to the first Main control instead of the Subform. How can I pass control to the Subform after all the Main Form controls have processed without using the Mouse. Thanks, Eddie

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Moving the focus to a SubForm is a two step process. First you move the focus to the SubFormControl and then you move the focus to a control on the SubForm. You would do that in the Exit event of the last control on the MainForm.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 08-07-2012, 11:50 AM
  2. Replies: 3
    Last Post: 04-17-2012, 10:28 AM
  3. Macro to navigate to tab or subform
    By larrydwilliams in forum Programming
    Replies: 1
    Last Post: 02-12-2012, 07:31 PM
  4. Write Code to Navigate from Subform to Subform
    By Swilliams987 in forum Programming
    Replies: 22
    Last Post: 02-04-2011, 11:30 AM
  5. Replies: 6
    Last Post: 11-05-2010, 10:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums