Setting Focus to Field on Continuous Subform

[asmith78]

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

[pbaldy]

Personally I do that type of thing in the before update event of the form, but if you want it there I think you need to set focus somewhere else and then back on the the control you're on.

[asmith78]

Hmm, okay now that I set focus to another field and back to the defWC field that is working but only if they click within the subform. If they click back to form and try assigning another error it doesn't give them the error message. Therefore, I put the code on the LostFocus of the actual subform and it doesn't seem to produce the message box either.