I am currently coding a VBA form to be used as a filtering screen, with combo boxes used to select the values to be flitered on, which add new complex filters when the OK button is clicked.
My main problem is that a user specification is to have one combo box affect the content of another. For example, with the eFashion universe I would want a City combo box to only show Cities for the State chosen in a State Combo Box. The other problem is that I only want to use the unique values for the objects in the data cube, rather than the LOV.
Does anyone have any ideas?
My main problem is that a user specification is to have one combo box affect the content of another. For example, with the eFashion universe I would want a City combo box to only show Cities for the State chosen in a State Combo Box. The other problem is that I only want to use the unique values for the objects in the data cube, rather than the LOV.
Does anyone have any ideas?