clear specific filter upon tab selection

[#1]

Hello,

I would like to be able to clear a specific filter when I go to another tab. The Clear Other Fields action doesn't seem to be doing that, and Clear All is not what I need.

Is there a way of doing this?

Thanks, Maria

[Oleg_Troyansky]

Maria,

you can add an Action to clear a field and attach it to the "Activate Sheet" or "Deactivate Sheet" events (see "Triggers" tab of the sheet properties)

[maneshkhottcpl]

Hi,

What u actualy want?

u want to clear all or few selectons?

[#4]

Hi Oleg,

I only have the option to clear all the filters with the Clear All Action. I need to clear only one or two filters.

Maria

[#5]

Manesh,

I want to clear a couple of the selections that I have previously made on another tab.

Maria

[#6]

I suppose I could use the Clear Other Fields Action and list all the filters but the ones that I need to clear. Doesn't seem like a great way of doing this since I will have to update that list if I add any other filters to the documents.

How can I add more than one field? Do I need to add another Clear All Fields Action for each filter?

Thanks, Maria

[maneshkhottcpl · Accepted solution]

Hi,

Please refer the attached document.

The macro is used to clear the selected list box, the macro activate whenever u leave the sheet.

Good Luck.

[Oleg_Troyansky]

Maria,

wow, I never noticed that even though there is an Action "Select in FIeld", there is no "Clear Field" action... I'm afraid you are stuck with macros, as Manesh suggested...

[#9]

Hi,

If you want to clear a single field you can use the Select in Field action but select a blank value ie ' '

regards

Lucy

[amars]

Sub CallClearField
 ActiveDocument.Fields("FieldName1").clear
end Sub
[\code]
See if this helps</body>