Force a combo box choice?

[mud2]

The complicated I can (usually) do, but the simple??
I have two combo boxes. I want to FORCE the user to choose something from each combo box...othgerwise I get a Null Error. Help me with this and I'll submit an ELEGENT way of using combo boxes!

[asingh]

Are you going to put a sumbit command button on the form..where the 2 combos reside.....?

Else how will the event fire that checks if combos have been selected.....?

[mud2]

Under the button that continues after the combo boxes (shouldhave) been checked:
Test if the Combo box values are true or false. (False means not null)
If False
Do whatever...
Else
MsgBox("Choose!")
End If

Works like a charm!

[Saurabhk]

Hi mud2,

Try the following code


Private Sub Command5_Click()
If IsNull(Combo0) Then
MsgBox "PLEASE SELECT A"
Exit Sub
End If
If IsNull(Combo2) Then
MsgBox "PLEASE SELECT B"
Else
SEL1 = Me.Combo0.Value
SEL2 = Me.Combo2.Value
Text6.SetFocus
Text6.Text = SEL1 & " " & SEL2
Me.Combo0.Value = Null
Me.Combo2.Value = Null
End If
End Sub

Hope it helps

[CFDM]

If IsNull(me.txtfield)=true or me.txtfield = "" then
MsgBox("Please select a value")
Exit Sub
End if
me.txtfield.setfocus

[CORYWP]

I would use a toggle for a submit button and enable it when both combo box's are not null.