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

    Move from Parent to Child form when tabbing thru all fields in Parent

    I have a Parent/Subform form structure. I would like to pass control to the subform when the operator tabs or hits enter through all the fields in the Parent form. I tried using the On Exit event, but it doesn't differentiate from an exit due to a mouse click and one due to tab or enter key. 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,922
    Put a tiny (1 pixel) control as the last control on the Form and use the EnterEvent to move the focus to the SubForm.

  3. #3
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313
    RuralGuy, your solution worked. Instead of making it small, however, I made it an unbound control with background and borders transparent. Thanks, I'll use this a number of places. Eddie

  4. #4
    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,922
    You're certainly welcome. Glad we could help.

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

Similar Threads

  1. Parent Child Relationship
    By Guru86 in forum Database Design
    Replies: 1
    Last Post: 06-20-2013, 10:48 AM
  2. How to make Parent field store sum of child fields
    By Alexandros in forum Database Design
    Replies: 10
    Last Post: 03-19-2012, 10:41 AM
  3. Passing value from parent to child form
    By Pragmatic in forum Forms
    Replies: 1
    Last Post: 12-02-2011, 07:23 PM
  4. Replies: 2
    Last Post: 09-16-2011, 06:11 PM
  5. Problem using Parent/Child Form/Subform
    By EvanRosenlieb in forum Forms
    Replies: 4
    Last Post: 06-27-2011, 05:25 PM

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