Pareto Select, Clear other field action

[#1]

Noob here 😄

hello , i have fews button that do a parato select by client of sum(sales) in diferent percentage , but i want first clear the selection that was make for the first parecto select button before make the new parato ,so i add a action called :

Clear Other Fields , and select the field client but this not work

now i am try make a module for get it work and i do this:

Sub clearcliente

ActiveDocument.Fields("cliente").Clear

Sub End

but say me syntax error

so i need a little help here , thanks.

[Oleg_Troyansky · Accepted solution]

As an advise - stay away from macros. Create an Action "Select" and specify null() or "*" as the selection string. That will result in clearing the selection that you want. Then you can apply the next Pareto Select.

[#3]

work like a charm , thanks again !