Set Focus to subfrm on Tabbed Page

[libraccess]

My Main form has outgrown itself so I have set up two tabbed pages.
Both have two subforms. Depending on 1st tab page mainform control choice I want to set focus to certain subforms.

Private Sub ContractorFK_LostFocus()
If Me.ContractorFK = "" Or IsNull(Me.ContractorFK) Then
MsgBox "Contractor Name is Required"
Exit Sub
End If

If Me.ContractorFK = 5 Then


'Contractor 5 is AppleFields
Me.frmSubTransTo.SetFocus
Exit Sub
End If
If Me.ContractorFK = "7" Then
'Contractor 7 is LeftField
Me.frmSubDel.SetFocus

Exit Sub
End If
End Sub

So the red line the subform is on the second tabbed page and does not work(focus just moves to the next control after [ContractorFK] )
The green line works just fine
So how is the second tab page referenced 2nd tabbed page Name is TransferForms

[RuralGuy]

If you solved your issue, do you care to share your solution with others that read this Forum?

[libraccess]

No I'm tooo embarrassed as it was a simple error, the query for some reason, whilst still appearing to be in the properties had actually dropped the fields in query by design and I obviously was not looking hard enough.

[RuralGuy]

Thanks for sharing!