Hi,
Having a odd problem but I'm sure I'm just overlooking something.
I have a combo box, that I need the users to select one of the items. If they leave it blank I want a message to appear telling them what to do.
I was using this code
Private Sub Form_BeforeUpdate(Cancel As Integer)
If (IsNull([Combo2])) Then
MsgBox "Please Select a Edit Type", vbOKOnly, "Edit Type"
Exit Sub
End If
End Sub
and that works, but only if the bound field is a text field. But my combo is bound to a number field, and it doesn't work. It doesn't give me any message at all.
What am I missing?
Having a odd problem but I'm sure I'm just overlooking something.
I have a combo box, that I need the users to select one of the items. If they leave it blank I want a message to appear telling them what to do.
I was using this code
Private Sub Form_BeforeUpdate(Cancel As Integer)
If (IsNull([Combo2])) Then
MsgBox "Please Select a Edit Type", vbOKOnly, "Edit Type"
Exit Sub
End If
End Sub
and that works, but only if the bound field is a text field. But my combo is bound to a number field, and it doesn't work. It doesn't give me any message at all.
What am I missing?