Automatically moving from tab to tab

[iBasho]

I have developed a form with 5 tabs (2 of which have subforms). Currently, the users get to each tab by clicking on the tab at the top when they are finished entering data on that page. (it does not move to the next tab when the user gets to the bottom of the page. I do have two subform on tabs 2 and 4 which will allow a user to add unlimited number of records). Is there a way that the focus will move to the next tab once the user reaches the last field on the previous page? Is there anything special that needs to be done on the tabs that have subforms?

Thanks in advance for your help!

[MSeda]

you can use the following code to go to another page when the Tab key is pressed.

Private Sub Equipment_Notes_KeyDown(KeyCode As Integer, Shift As Integer)
 
If KeyCode = 9 Then ' 9 is the tab key
DoCmd.GoToControl "Page77" 'what ever the name of you page is
End If
 
End Sub

you could also add the keycode for the arrow keys if you like

[iBasho]

Thanks for the reply MSeda. Unfortunately it did not yield good results.
When I tab through the fields and I am on the last field for that page it enters a new record and the focus does not move to the next tab (page). Even when I am finished tabing through that second record it returns the focus on the first field of the first record on that same tab (page).

This is the code I entered:

Private Sub Equipment_Notes_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 9 Then
DoCmd.GoToControl (Page3)
End If
End Sub

[Rabbit]

Have you tried "Page3" like in MSeda's example instead of (Page3)?

You might also want to make sure it's the last control on the tab before executing the code with a .TabIndex check.

[iBasho]

Thanks Rabbit. Fixed the problem.

[Rabbit]

Not a problem.