How to unlink two text objects present in two different sheets without using triggers

[Anonymous]

I use two text objects to clear all the selections. Sheet 1 has default selections which means on Clear all default selections should be retained. sheet 2 has nothing which means on clear all here nothing should be selected. but on clear all in sheet 2 default selections of sheet 1 is getting carried to sheet 2 as well. Kindly help me with this

[sudhirpkuwar]

On Clear All on Sheet 1 do you still have the default selection.....?

According to me Clear All should clear all the field selection unless and untill you have any list box with 'Always one Selected Value' selected.

[Anonymous]

No Sudhir, I've disabled 'Always one selected Value' in sheet 1 but since sheet 1 has default selections, the selections are carried for sheet 2 aswell

[sudhirpkuwar]

You can give a trigger to Sheet 2 to clear that field....

So when you go to Sheet 2 that field will be deselected

[Anonymous]

Could you please attach an example to do this, It would be great if the trigger could applied at object level rather than applying a field event trigger.

Thank you so much for your response

Pancham

[sudhirpkuwar]

I think we cannot assign Object level trigger

You can set Sheet 2 to clear that field selection in the same way as you assigned the default selection (Sheet Properties)

[Anonymous]

I'm currently doing the same way. But Since i have many sheets like sheet 2 which is getting impacted, I would want a simpler solution which would be universal.

thank you

[sudhirpkuwar]

Try to put default selection for that sheets too....

If you don't find this helpful can you share your qvw...?