Trigger on selections

[#1]

Hi all,

I have a document with 3 sheets. The data is regarding shipments in and out. There are 4 types of shipments. The first sheet shows an overview of all shipments (type can be selected), the second sheet shows a detailed view of shipment type 1 and the third sheet shows a detailed view of the remaining shipment types. I have used set analysis to ensure only appropriate data are shown on each sheet.

The problem is that when opening the second sheet, I want an automatic selection to be made for shipment type 1 (to ensure list box functionality is maintained..showing grey where it should etc). This is simple to do with triggers. Triggers would also help to remove the selection when leaving the sheet.

But if shipment type 1 was selected on the first sheet before opening the second sheet, I do not want to remove the selection when leaving the second sheet.

I only want to remove it if the selection was set by opening the second sheet.

Hope this was understandable.

Any idea on how to do this?

Regards,

Ståle

[#2 · Accepted solution]

Fixed it. Used a trigger on leaving the first sheet to set the value of a variable to the current selections. When leaving the second sheet, it checks the new variable if the selection was made already. If yes, it does not remove the selection, if no, the selection is removed.

Ståle