Combo box checking if record selected

[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???

 

[Guest]

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

 

[Guest]

Thanks for the feedback. This is a unbound combo box. I thought I could in
code check if a item was selected?

 

[Douglas J. Steele]

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.

 

[Guest]

Thanks for the feedback.

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.