Thanks for the quick response zmbd and sorry for being vague. I'll try and clarify.
I'm trying to make it so that as a user tabs through one of the datasheet subforms, when they get to the end of a record contained in the datasheet it will jump to the appropriate subform and record in the datasheet in that subform.
In looking at the link I provided in my first post, I was able to figure out how to set focus to cells in other subforms while tabbing... but with odd/strange behavior. Like when I get to the last record and press tab in the first subform the next record in the current subform is selected before the setfocus code executes.
The user experience I'm after is that they will be able to tab through all of the data as if it were one big datasheet, even though there are 5 subforms that they are jumping between.
Below is a sample of the simple code I've written... I'm pretty sure it's too simple:
- Private Sub PP10_KeyDown(KeyCode As Integer, Shift As Integer)
-
If Shift <> acShiftMask And KeyCode = vbKeyTab Then
-
Me.PP10.SetFocus
-
Me.Parent.PY_PP_Spring_Filter.SetFocus
-
Me.Parent.PY_PP_Spring_Filter.Form![PP11].SetFocus
-
End If
-
End Sub
-
-
Private Sub PP1_KeyDown(KeyCode As Integer, Shift As Integer)
-
If Shift = acShiftMask And KeyCode = vbKeyTab Then
-
Me.PP1.SetFocus
-
Me.Parent.PY_PIT_Job_Filter.SetFocus
-
Me.Parent.PY_PIT_Job_Filter.Form![Notes].SetFocus
-
End If
-
End Sub