Unable to SetFocus on a Main form control from Subform (1 Viewer)

[abzalali]

Dear Expert,
I'm using form with subform. Main form header contain a combobox. I need to check the combobox is null or not before update a subform filed. If combobox is null then its back to Main form combobox from subform. The code below that I'm trying to:

Private Sub AssignTo_BeforeUpdate(Cancel As Integer)
    If IsNull(Forms!frmDepartmentReview!cboDepartment) Then
        MsgBox "You must select Department first", vbInformation
        Forms![frmDepartmentReview]![cboDepartment].SetFocus
    End If
End Sub

Then I'm getting 2110 run time error
Access can't move the focus to the control cboDepartment.

Please help me.

Thanks
Mir

 

[Extra_Cover]

I have had similar problems. Try setting the focus to form first then set focus to control

Forms![frmDepartmentReview].SetFocus
Forms![frmDepartmentReview]![cboDepartment].SetFocus

 

[abzalali]

getting same error with this code:
If I press debug then go to the line:

Forms![frmDepartmentReview]![cboDepartment].SetFocus

 

[Frothingslosh]

Here is a very handy resource for issues like this:

http://access.mvps.org/access/forms/frm0031.htm

 

[Extra_Cover]

Try removing the [] brackets.

Forms!frmDepartmentReview.SetFocus
Forms!frmDepartmentReview!cboDepartment.SetFocus