OK, so I have a subform and I want to set focus to a combo box on the subform after lost focus of the combo box field. I need for the user to make a selection from the combo box before moving on. I am placing the code on the LostFocus event procedure of the subform and it works as far as giving me my message but it WILL NOT set focus back to that field no matter what I try. Here is my coding and I am also providing screen shots.
Private Sub defWC_LostFocus()
If (IsNull(defWC) And Len(defAttCode)) > 0 Then
MsgBox "Please enter Who Committed the error.", vbOKOnly, "Validation"
Me.defWC.SetFocus
Exit Sub
End If
End Sub
Any assistance is GREATLY appreciated.
Thanks,
Amy