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.
Sry, i dnt completely uderstood your question earlier.
you can do this using macro.
you macro should be similar as follow. (Untested macro)
ActiveDocument.Variables("variField").SetContent val.item(0).text, true
IF variField = 'REFUND' THEN
ENDIF variField = 'VOIDS' THEN
Map this function to on chnage field trigger in document property.
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.
Test.qvw 115.8 K