combo box selection

D

Dana

I have a form with few combo box, I want to make the user choose one of the
options in all the boxes. How can I make sure the user filled all the combo
boxes before continue?

Thanks

Dana
 
O

Ofer

On the before update event of the form you can enter the code that check the
values in the combo's if they are empty, and stop the exit if they are not
all filled

If isnull(me.combo1) or isnull(me.combo2) or isnull(me.combo3) then
msgbox "Fill combo's
cancel=true
end if
 
F

fredg

I have a form with few combo box, I want to make the user choose one of the
options in all the boxes. How can I make sure the user filled all the combo
boxes before continue?

Thanks

Dana
Click to expand...

Code the Form's BeforeUpdate event:

If isNull(Combo1) Or IsNull(Combo2) Or IsNull(etc) .. Then
MsgBox "You must fill in each combo box."
Cancel = True
End If
 
Top