empty combo box list

[mattwebb]

hi, any help on this would be appreciated.

I have combo boxes on a form, sometimes they will be populated and sometimes they wont. What i would like to do is display a message to the user explaining why there are no records to chose from in the drop down list on the combo box when they click on the box.

so...what i am trying to find out is - is there are way of counting the number of records that are in the combo list so i can display my messages when there are 0???

thanks in advance

p.s. i have searched the forums to no avail

 

[dcx693]

Me.cboComboBox.ListCount

will get you a count of how many items are in there. Perhaps it would be better to just disable the control if there are no relevant choices to make from it.

 

[mattwebb]

many thanks for the advice...this is exactly what i wanted.