Setting Focus from a sub form to a different sub form?

[d9pierce1]

Private Sub cboAddressType_GotFocus()
    If IsNull(Forms!frmBusiness!sfrmBusiness.Form!cboCategoryEntity.Column(0)) Then
 
    MsgBox "You Must Enter Or SELECT an ENTITY before Adding an Address! "
    Forms!frmBusiness!sfrmBusiness.Form!cboCategoryEntity.SetFocus
'Exit Sub
End If
End Sub

Hi all. I have a primary form and on that are two sub forms.
When i focus on my second sub form, and the first field is null in subform one


Then I want to msgbox that, setfocus to the first sub form / Field!


Main Form = frmBusiness - Single Form
SubForm 1 = sfrmBusiness - Continous Form - Source Object = sfrmBusinessEntity
SubForm 2 = sfrmBusinessAddress - Continous Form - Source Object = sfrmBusinessAddress
Field I am trying to set focus on is in SubForm 1 and is called cboCategoryEntity


Have tried many things, msgbox works but wont shift the focus?
Any suggestions please!
Thanks
Dave

[Minty]

Try setting focus to the subform CONTROL, then set focus on the control on the sub form.

[d9pierce1]

Private Sub cboAddressType_GotFocus()
 If IsNull(Forms!frmBusiness!sfrmBusiness.Form!cboCategoryEntity.Column(0)) Then
 
    MsgBox "You Must Enter Or SELECT an ENTITY before Adding an Address! "
    Forms!frmBusiness!sfrmBusiness.SetFocus
    
'Exit Sub
End If
End Sub

Thank you Minty,
That worked just fine!
Thanks
Dave

[Micron]

You cannot set focus to a form if it has any enabled controls - can't say whether or not that includes enabled but hidden. The last control that had the focus is where the focus will go, not to the form itself. Not sure if you have to set focus to a subform control first, then a control on the subform or whether you can do so directly. Regardless, if the subform contains enabled controls it can't take the focus anyway. What is the purpose of trying to set focus to your subform?