Checking if a RowSource return nothing.

[Gannet]

I have several combo boxes to select categories and subcategories. When I choose a main category I unlock the next combobox and have the row source pull values based on the main category. Next you need to select a subcategory. Sometimes the subcategory will have a subcategory itself. In this case I want to show that next combobox and allow an option to be checked otherwise I don't want to show that box. So the question is: How do I write code to check if a rowsource has returned zero options from a table?

Sorry about the accidental post

 

[RuralGuy]

The Me.ComboBox.ListCount property contains the number of rows in the RowSource of the ComboBox.

 

[Gannet]

Thanks

Thanks for the help. I knew it was simple but sometimes you just don't see what is right in front of your face .

 

[RuralGuy]

Glad I could help.