davegri seems to be off line, so maybe I can pitch in. If this code is on the subform and you want focus to shift to a control on the main form, then
Code:
Private sub chkYesControl_AfterUPdate()
if chkYesControl = true then
Forms!NameOfYourMainForm.NameOfOwner.setfocus
end if
End Sub
Sorry if I'm out to lunch!
Can't say I'm a fan of having controls in a form/sub form relationship where any controls have the same name.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.