Combo Box NULL value

[David]

Hello all,
I have a form setup so that if a particular value in
combobox 1 is selected, it will show combobox2. I would
like to write code on combobox2 LOSTFOCUS event that will
force a value to be selected from the list. The values
selected write to a table, but not every record is going
to show combobox2, so I can't set the table field
property to required. I have tried an IF statement, IF
combobox2 is null then ........ I've tried, IF combobox2
= "" then........ What is the default value of a combo
box if nothing is selected from the dropdown?

Thank you for reviewing this question.

 

[Guest]

This is an example of my code that doesn't work.

If Combo4 Is Null Then
MsgBox "a"
Else
MsgBox "b"
End If