How do I check if an item has been chosen in a combobox?

[Gimp]

I tried IsNull(ComboBox) and it doesnt work.
Please help
Thanks.

 

[Gimp]

If i try to write this:
[cmbMyCombo]![Text]=""
i get a type mismatch error

 

[jfgambit]

Are you trying to validate this on a Form?

 

[Gimp]

yes

i do all the field validation stuff in a macro, displaying msgboxes if a some field is empty and such. its all being run the moment you click the save button.

 

[jfgambit]

Add the following to the On Click Event of the button:

If isnull(me.comboboxname) then
Msgbox "You need to select an item from the ComboBox",vbokonly,"Validation Error"
Else
Your code to run your macro here...
End if

HTH

 

[Gimp]

is it possible to do it through a macro's condition?