Alternate States query

[hopkinsc]

Hi all,

can anyone tell me how i can pass a selection from 1 list box on a sheet (inherited state) to another list box on another sheet (in state2).

I have attached an example.

in the example i have 2 alternate states, ignore State1 as this is used on another part of the qvw.

Thanks

[hopkinsc · Accepted solution]

Hi all,

for anyone else who needs to do this i have managed to get it working using an on activate sheet trigger.

see attached sample

[sgrice]

Then you are back to

Then use a Trigger with action

Select in Field

myField

=concat({myFromState}distinct  '"'&myField&'"'  , '|') & ')'

Remember to change the STATE of the action to the state you want it to effect.

set the trigger on the TAB open Trigger.