Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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.
Try using Trigger, it would allow you do what you want. Try something like "OnSelect" event under 'Field Event Triggers'.
Regards, tresesco
@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..
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.
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..
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.
hi richardo,
I hope the attach application helps.
@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..
Settings -> Document properties -> Triggers and there you would find it.
@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..