Invalid Property Value error with form

[TyeReece]

I have a form that hides rows, based on the value in a combo box (Male/Female). When the form opens the first time, the combo box is blank. Once you make a selection it hides rows just fine. However, if you go back to the form and try to clear it to see all the rows (Males & Females), I get the "Invalid Property Value Error". What is the code to clear the value in the combo box without getting this error? Thanks.

 

[BrianB]

Just a guess, but you probably need to unhide all the rows before doing anything else.

 

[tusharm]

Is there a reason you are not using Excel's filtering capability? It does exactly what you want! See Data | Filter > Autofilter

I have a form that hides rows, based on the value in a combo box (Male/Female). When the form opens the first time, the combo box is blank. Once you make a selection it hides rows just fine. However, if you go back to the form and try to clear it to see all the rows (Males & Females), I get the "Invalid Property Value Error". What is the code to clear the value in the combo box without getting this error? Thanks.

 

[TyeReece]

Sorry it has taken me so long to respond. Thanks for your response. I've come up with a solution, but to answer your question, I'm not using Autofilter for two reasons. One, the amount of data that is available for users to view is large. They are able to select only those variables that are of interest to them. Secondly, I will be putting this file on the web and the people who will be using it have various levels of excel knowledge, mostly novice users. I am trying to avoid having to educate them all as to how to use autofilter.

 

[TyeReece]

Sorry it has taken me so long to respond. Thanks for your response. I've come up with a solution, but to answer your question, I'm not using Autofilter for two reasons. One, the amount of data that is available for users to view is large. They are able to select only those variables that are of interest to them. Secondly, I will be putting this file on the web and the people who will be using it have various levels of excel knowledge, mostly novice users. I am trying to avoid having to educate them all as to how to use autofilter.