Combo box checking if record selected

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box that a valid selection can be null or zero length based on
the table. The user must select from the list. How can you tell if a
selection was made???
 
In the form BeforeUpdate event you can write the code

If Trim(Me.ComboName) & "" = "" Then
MsgBox "Need to select a value"
Cancel = True ' wont let the user continue
End If
 
Thanks for the feedback. This is a unbound combo box. I thought I could in
code check if a item was selected?
 
I don't believe you can for a combo box. List boxes have a both a Selected
property and an ItemsSelected collection, but combo boxes don't.
 
Thanks for the feedback.

Douglas J. Steele said:
I don't believe you can for a combo box. List boxes have a both a Selected
property and an ItemsSelected collection, but combo boxes don't.
Click to expand...
 
Back
Top