Hi friends

I have a combobox on a Form that I check to make sure the user had selected a value before he exits the Form.

I test for ChaplainCombo = '0' and give a message that this field is required and prevent the form from closing.

But if the user deletes the entry in the ChaplainCombo, the Form closes.

So I test for empty string "" as well, but the form still closes.

Here is my code in the "Unload" event:

        MsgBox "Chaplain Combo='" & ChaplainCombo & "'"
    If ChaplainCombo = 0 Or ChaplainCombo = "" Then
    ReturnValue = MyMsgBox("You are Must enter a Chaplain's name!", "Missing Chaplain's Name", _
         , , FormBackColor:="#FFAAAA", WindowHeight:=2745)
    Cancel = True
    End If


I msgbox ChaplainCombo and I get an empty string.