Format Dependent Combo Boxes

[Michelle]

I have a series of combo boxes on a subform which are populated based on values chosen from either the main form or the previous combo boxes on the subform. Some of these boxes will have no values to select from. If there are no values in the combo box (based on the previous selections), I would like the combo box disabled so the user does not have to pull down the arrow and find there is nothing to select. I am thinking this would be done after the requery of each selection

How should I do this

Thank you

 

[Sam D]

Examine the combo's ListCount property after populating the combo. Something
like....

cboName.enabled=cboName.ListCount<>0

HTH
Sam

I have a series of combo boxes on a subform which are populated based on

values chosen from either the main form or the previous combo boxes on the
subform. Some of these boxes will have no values to select from. If there
are no values in the combo box (based on the previous selections), I would
like the combo box disabled so the user does not have to pull down the arrow
and find there is nothing to select. I am thinking this would be done after
the requery of each selection.