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
Sorry about the accidental post

Last edited: