Tabing

[IanT]

I have a form which contains two subforms. I want to tab from one subform to the other. Can anyone help.

I can tab from the subforms to the main form! by using:
Forms![frmPrintActivity]![PrintIDNumber].SetFocus

 

[David R]

Private Sub FieldInFirstSubform_KeyDown(KeyCode As Integer, Shift As Integer)
    If IsNull(Me.FieldInFirstSubform) Then
        If KeyCode = 9 And Shift = 0 Then
            KeyCode = 0
            Me.Parent!NextSubform.SetFocus
        End If
    End If
End Sub