Hey everyone.
I searched but wasn't able to find any answers.
I have a form with a few cascading Combo boxes. Once the user has selected a combination of data, they click a button that will apply a filter to the form based on the selections they made. That works no problem, but when I knowingly make a selection where I know there is no data; the form comes up empty (as it should) but than my combo boxes are than reset to Null. I would rather they still show the selections made, and perhaps come up with a msg saying, “there are no records matching that selection”.
I would rather not limit the combo boxes to only the combinations that have valid data.
Any thoughts on why the combo box resets to null?
Thanks
I searched but wasn't able to find any answers.
I have a form with a few cascading Combo boxes. Once the user has selected a combination of data, they click a button that will apply a filter to the form based on the selections they made. That works no problem, but when I knowingly make a selection where I know there is no data; the form comes up empty (as it should) but than my combo boxes are than reset to Null. I would rather they still show the selections made, and perhaps come up with a msg saying, “there are no records matching that selection”.
I would rather not limit the combo boxes to only the combinations that have valid data.
Any thoughts on why the combo box resets to null?
Thanks
