Show sheets based on variable

[#1]

Hi,

I've done this million times before and I don't know why it doesn't work now. I'm trying to show a different sheet based on a selection in a list box. I've done it with a variable. Please, do look on my qvw and tell me what I'm doing wrong.

Thanks,

Adrian

[jpenuliar]

possibly a field event trigger on Date to change variable value

[Gysbert_Wassenaar · Accepted solution]

You need to do a bit of dollar expanding. See attached qvw.

[#4]

Use =$(vSheet)=0,=$(vSheet)=1, =$(vSheet)=2 in the condition. Hope this helps.