How do i restrict current selection on different sheet

[#1]

Hello, find attached. how do i restrict current selection control to one sheet?

having field that has always one selected value.

[#2]

Yes, it solves my problem but i couldnt do it myself. How did you do it?

[#3]

How did you do this am not getting it

[kavita25]

Using Alternate State.

Main Sheet : Grp1 for both the list box and current selection.

Menu 2 Sheet : Grp2 for both the list box and current selection.

Hope you get it.

[avinashelite]

Hi Emac,

You mistake is, First you have created single select value and you have saved it I guess, then later you have applied Alternate state on it that's why its taking it as default state in our case we applied alternate state first then selected the single select value.