SubForm Going into Edit

[katc]

Hi There,


I have created a form called Patient that has a subform called Case. The PtName has this to force users to populate the PtName in the OnExit event.

If IsNull(Me.[PtName]) Then
Cancel = True
MsgBox "You must enter a Patient Name. Please enter a name to proceed!"
Forms!EnterPatient!PtName.SetFocus
End If

I added a combo box to select a patient name. I just used the wizard. When you select a Patient Name from this list. It goes to the record, however the Subform goes into edit (the little pencil shows up) and you get stuck in it. Why is this happening?

[ItsMe]

I would not use the OnExit event. I would use the AfterUpdate event of the control or validate multiple controls in the Form's BeforeUpdate Event.