Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I am struggling with an issue for last 4 days. I am posting the sample below.
Actually i am having two listboxes 'Tables' and 'Charts' .
Tables have field tables and Charts have field Chart . Both fields have trigger .
Open the qvw i have explained in it the issue.
I added the charts trigger to both table ans charts objects.
It works now, see attached.
Hi
The problem here is that each trigger only looks at the value of the field you are dealing with, it doesn't take any action when that field is cleared, therefore, when a field is cleared it doesn't know which sheet to activate and therefore defaults to the sheet immediately prior to the active one.
Your Trigger on Tables should be:
=if(GetFieldSelections(Tables)='A','SH02',
if(GetFieldSelections(Tables)='B','SH03',
if(GetFieldSelections(Tables)='C','SH04',
if(GetFieldSelections(Tables)='D','SH05',
If(GetFieldSelections(Charts)='P','SH06',
if(GetFieldSelections(Charts)='Q','SH07',
if(GetFieldSelections(Charts)='R','SH08')))))))
Your trigger on Charts should be
=If(GetFieldSelections(Charts)='P','SH06',
if(GetFieldSelections(Charts)='Q','SH07',
if(GetFieldSelections(Charts)='R','SH08',
if(GetFieldSelections(Tables)='A','SH02',
if(GetFieldSelections(Tables)='B','SH03',
if(GetFieldSelections(Tables)='C','SH04',
if(GetFieldSelections(Tables)='D','SH05')))))))
And finally, you only have triggers placed On Select, and a clear function is not a select, so you also need to add the exact same trigger to the on Change button.
Good !!
And thanks !
Your welcome,
Just note that you should do the same for table list box