Combo Box NULL value

  • Thread starter Thread starter David
  • Start date Start date
D

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.
 
This is an example of my code that doesn't work.

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