activate sheet based on selection in multibox.

[#1]

I had a muti box conenction with values (postpaid, prepaid).

On the selection of 'prepaid', sheet1 should be activated and on selection of 'postpaid' sheet 2 should be activated.

can anyone suggest me how can i achieve this?

[#2 · Accepted solution]

Hi,

You can achieve this by writing field Event triggers.

Go to Properties-Document Settings-Triggers-Field Event Triggers.

Then on The required field add an action :

Action Type : Layout

Action : Activate Sheet

Here give the sheet id which you want to activate.

Hope this helps!

[#3]

Hi,

   PFA......... Hope it is helpful for you.........

Regards,

Nirmal.

[#4]

hi...

[lironbaram]

go to sheet1 then right click the mouse and select properties

then in the general tab , in the show sheet select conditional

in the condition box insert match(getfieldselections(Field1),'postpaid')>0

where Field1 is the field in your multibox

for sheet 2 insert the condition match(getfieldselections(Field1),'postpaid')>0

[vikasmahajan]

Hii

PFA

[tresesco]

PFA. Using a trigger.

[#8]

Hi,

Go to the Sheet1 properties->General->Conditional->In expression write =values='prepaid'

Go to the Sheet2 properties->General->Conditional->In expression write =values='postpaid'

[thomas_skariah]

Hi Kausalya,

Try this.

Regards,

Tom