Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012
    Posts
    56

    Unanswered: Navigating between two seperate subforms

    Hello all

    I have a main form with a tab control with three pages. On the first page I have three subforms each one has table linked to the main form. What I am trying to do is update one field in this table which I have the tab stop set to this field only. When I tab down the table on this field updating as I go till I reach the end of the table and I now want to move to the subform and start the same process on the next form. I can do this by using the Ctrl+Tab key but want to do ths with just the Tab key. Any help would be great thanks Bob

  2. #2
    Join Date
    Nov 2011
    Posts
    413
    Maybe this will help.Substitute the name of your page instead.

    Select Case Me.tabExample.Value ' change tabExample to name of your page
    Case 0
    ' Do something for the first tab
    Case 1
    ' Do something for the second tab
    etc...
    End Select

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •