Checking if a selection of value is allowed or not

[amars]

Hi all,

I am writing a macro, in which I have to send Territory (US, ASIA, Europe) wise reports to each Manager. Now in a macro when I select a manager & suppose for him no selection for a Territory (i.e. ASIA) is allowed still When I use

ActiveDocument.GetField("Territory").Select "APAC"

it clears the Manager's selection & send all the data for that Region to the manager for that selection. Now I want to check in a macro if a particular selection of value is allowed at an instance(with some selection already) or not . How to do that?......... Thanks in advance.

Cheers

Amar[:(]

[disqr_rm]

Hi Amar,

Why don't you use Section Access to reduce the data? Why Macro?

[#3 · Accepted solution]

you could use ActiveDocument.GetField("Territory").GetPossibleValues to get the list of all values of the Territory field compatible with the current selection, and then check the value you want to select is contained in this list before doing the selection

[amars]

Thanks george,

Already impleted that.