Select a sheet by selecting a value from a multibox

[hopkinsc]

Hi, i have a multibox with various options.

Transactions

Sales

Operational

This multibox is on my SELECTIONS tab. Basically the user will select what it is they wish to look at (eg, Transactions) then a drop down list of available options appear

Transactions

Refunds

Voids

Paid Outs

Staff Discount

etc

If the user then selects 'Refunds', i then want the user to be automatically taken to the 'Refunds' tab.

Is this possible?

[#2]

Hi,

You can use conditional show option in sheet property and achieve this.

Take for example you user select 'Refund'

Right click on Refund sheet and Go to Sheet property ---> General .--> Conditional Show

your expresion should be as follow.

Field Name = 'Refund'

Hope this may help you.

- Sridhar

[hopkinsc]

Thats fine for showing the sheet, but i also want the user to be taken to that sheet without having to click on 'Refunds' then click on the sheet tab.

I have looked in the triggers and tried to set up 'LAYOUT', and 'ACTIVATE SHEET' but it just askes for a sheet id. I was hoping i could use an expression to say that when REFUNDS are selected, actovate the Refunds sheet.

[#4]

Hi,

Sry, i dnt completely uderstood your question earlier.

you can do this using macro.

you macro should be similar as follow. (Untested macro)

sub ACTIVATESHEET

set val=ActiveDocument.Fields("Field").GetSelectedValues
ActiveDocument.Variables("variField").SetContent val.item(0).text, true

IF variField = 'REFUND' THEN
ActiveDocument.Sheets("REFUND").Activate

ENDIF variField = 'VOIDS' THEN
ActiveDocument.Sheets("VOIDS").Activate
END

End Sub

Map this function to on chnage field trigger in document property.

- Sridhar

[#5 · Accepted solution]

Hi,

You can use "Triggers" to resolve this problem.

In Documents Properties, "Triggers", "Field Event Triggers", "On Selection".

Add / Layout / Activate Sheet.

In field "Sheet ID" you need the sheet that you want to show.

See the example.

[hopkinsc]

Thanks Eduardo, Thats exactly what i wanted..