Combo Default Message

[dan.cawthorne]

Happy New Year To Every One,

Can Some Point Me in the Right Direct On How to Achieve Having a
Default Message In My Combo Box

the Message I Would Like Is "Please Select" if a Item has not be
selected.

The Record Source's vary from tables, Select Query's or value List.

Ive Just Setting something up on the Default Option In the Properties
Dialog but no luck.


Regards

Dan

 

[Klatuu]

I would suggest using the form's Before Update event to check for a value in
the combo box:

If IsNull(Me.MyCombo) Then
MsgBox "Please Select Item in MyCombo"
Cancel = True
Me.MyCombo.SetFocus
End If