How can I check a combo box content or value or something

[Marco]

Hi. I need to check if my combobox has something on it, what I mean is if my
users choose any value.

I need something looked like:

if combo1 then
msgbox "you must choose an option on Combo1"
exit sub
end if

How can I do something looked like?

Regards,
Marco

 

[Mark A. Sam]

Marco,

In the AfterUpdate event of the combo type,

if IsNull(combo1.text) then
msgbox "you must choose an option on Combo1"
End If

 

[Ron2006]

That identical test can be made on any other condition/event on the
form - and probably should be otherwise if they never touch the field
the afterupdate code would never be executed.

Ron