Moving between subforms

[rdw456]

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 next 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

 

[boblarson]

Place a text box on each subform and set its height and width to .01". Then set it as the last in the subform's tab order. And in the Got Focus event of it have it choose the next page:

Private Sub ControlNameHere_GotFocus()
   Me.Parent.TabControlNameHere = Me.ParentTabControlNameHere + 1
End Sub

You would leave the Me.Parent part exactly as shown and substitute TabControlNameHere with your actual main tab control name (not the name of one of the pages but the actual whole tab control).

 

[rdw456]

Hello Bob Thanks for the quick reply. I have tried what you have sugested but did not work for me. I am using continuious forms on all subforms and when I get to last record it stops and will not go any further so not sure where to go next.

Thanks Bob

 

[boblarson]

Hello Bob Thanks for the quick reply. I have tried what you have sugested but did not work for me. I am using continuious forms on all subforms and when I get to last record it stops and will not go any further so not sure where to go next.

Thanks Bob

Sorry I didn't respond sooner. Can you post a copy of the database (with fake data) so we can take a look? Be sure to run Compact and Repair first and then zip the file by right clicking on it and selecting SEND TO > COMPRESSED FOLDER.

 

[rdw456]

Hello Bob thanks for the reply I have changed my design and have gone away from continuous forms.

Thanks Bob