Skip to Content
0
May 18, 2015 at 02:59 PM

Layering two combo boxes without Dynamic Visibility

24 Views

Hi All,

I am looking to use two combo boxes (one on top of the other), however only one should be seen at a time.

This is dictated by a toggle button between Division and Region.

Normally this isn't too difficult, but I have queries tied to the destination cell when the selection changes. When I toggle between Division and Region, the combobox that gets suppressed drops its value (thus changing the cell contents and refreshes the query unnecessarily)

When I toggle back to the original selection, the selected cell does come back, but it changes the contents of the cell and the query refreshes yet again.

I was hoping to hide the combo box instead of dynamic visibility and keep the values selected, just not visible to the user.

Any ideas?

Thanks!