Sheet selection controlled by a listbox

[#1]

Hi,

I'm developing an app where Tabs should be hidden.

How could I switch between sheets using a listbox?

Thanks.

[Gysbert_Wassenaar · Accepted solution]

Add a conditional display expression to your sheets on the properties window of the sheets.

=substringcount(concat(MyField),'Value1') will show the sheet if Value1 is among the selected values.

You could also add a Activate Sheet action to the OnSelect trigger of the field in your listbox to activate the sheet if you select a value in the listbox. You'll need so logic to map the selected value to a sheet ID. Using the same values for the sheet ID's and the listbox values is an easy solution.

[#3]

Right Click on Tab ..

Go to sheet properties.

In "Show Sheet" select "Conditional"..

There you can write expression.. ListBoxField='FieldValue'

[lironbaram]

check the attach file

you should look at the tab properties to see the condition for each tab

[#5]

Ok, I see what you mean.

I'll use the OnSelect trigger I guess.

Thx.

[#6]

This is not what I actually needed. This would basically show/hide my tab. I don't want to hide it.

[#7]

I don't have QV installed on my current machine but I'll have a look at that.
Thanks.