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

  • Thread starter Thread starter Marco
  • Start date Start date
M

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
 
Marco,

In the AfterUpdate event of the combo type,

if IsNull(combo1.text) then
msgbox "you must choose an option on Combo1"
End If
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running a query and setting that value base on another combo box 3
Hide combo box with check box on another form 3
checking if combobox any item choose 2
Autocomplete problem 2
Unbound combobox AfterUpdate 5
Combo Box Visible Yes/No 3
Combo box choices based on another combo box 5
Combo box contents doesn't change when filtering combo box is chan 2

Back
Top