Combo Box

[Simonglencross]

Could somebody advise me on how to do the following
If I have a combo box called Marketing Sources for example which has the
following Walk in, Phone in etc how do I set it so the user has to select an
option and not leave it blank? I know its proberbly something to do with the
validation rule but not too sure.

Thanks

Simon

 

[Rajesh B. Patel]

Simon,

You can do this by making the table field that the combo box is bound to
"Required". To do this open the table of interest in Design View and
change the value of the Required property on the appropriate field to Yes.

Alternately, you can do do all sorts of validation and the like in VBA.
For example, in the Form_BeforeUpdate event you can ensure that the
combo box has a value stored before allowing the update.

raj