[ASK] how to make an activate multi box

[#1]

hello...

i wanna ask a question

i have a multibox with a field called "Area"

can i make this multibox to activate sheet?

example, when i click Area n choose Tokyo, then Tokyo Sheet will automatically activated and also i go to Tokyo Sheet automatically

how to do that?

please help..

many regards

thx...

[tresesco]

Try using Trigger, it would allow you do what you want. Try something like "OnSelect" event under 'Field Event Triggers'.

Regards, tresesco

[#3]

@tresesco

hello Tres...

i've tried what u suggested

sheet properties -> triggers -> choose object -> add triggers on activate

and i choose action "Toogle Select" with

1. field =Area

2. search string 'Tokyo'

but nothing is happening

more help please..

many thx..

[tresesco]

Hi, i think i misunderstood your requirement. you can do it in an easier manner. use conditional display property of sheet ( General tab -> Show Sheet -> Conditional), put there, Area='Tokyo'. it is done. if it doest help, please let me know.

[#5]

@tresesco

helo Tres..

that's one of a great idea

but what client want is that when i choose Tokyo, the Tokyo sheet will open and the sheet will go to Tokyo sheet without user have to click Tokyo sheet

just a lil bit more help please

many thx..

[tresesco · Accepted solution]

Coming back to Trigger:

Field Event Triggers -> On Select-> Action Type (Layout) -> Action (Activate Sheet) - > Sheet ID = If (Area='Tokyo', 'SH02')

SH02 - is your sheet ID of taregt sheet.

[deepakk]

hi richardo,

I hope the attach application helps.

[#8]

@tresesco

where is the menu Field Event Triggers?

because i can't fing "On Select" selection

@Deepak Kurup

great one Pak..

can u tell me how?

because i don't know what to do when i see ur solution

many tx to both of u..

[tresesco]

Settings -> Document properties -> Triggers and there you would find it.

[#10]

@tresesco

solved

i know ur solution

many thx tresesco..

@Deepak Kurup

solved also

u use macro, right?

i'm know nothing about it

but it also a great one

many thx Pak..