Get List of Answers from a list of selected values on another field

[mantaq10]

Hi all,

how do I get the list of values (Answers) from a field, say A based on a selection of values (Selected Values) from a field B using scripting or macros?

Regards, Atif

[vupen]

I think you are looking for something like this:

<code>

' Possible Values
Set val=ActiveDocument.Fields("ANSWERS").GetPossibleValues
For i=0 to val.Count-1
iChartCount = iChartCount + 1
msgbox(val.Item(i).Text)

Next

</code>

[#3]

pls attach a qvw file or a snapshot of that to get a clear picture of what exactly you want.

thanks

[mantaq10]

Thanks Upendra,

Actually, i want to get access to all the answers and non-answers, I dont have any field by the name of ANSWERS. I am looking for values which are considered as 'answers' by a selection of values on another field.

Look at the attachment, i want a list of the three cities, Atlanta, Dubai Jeddah as a collection/array/variable etc.

[mantaq10]

The right terminology is "Optional" and "Excluded" values....

Is there a way to programmatically get access to them?

NOOb pleads.....:)

[mike_garcia · Accepted solution]

The Function concat() will give you a string containing all the possible values in a field. You specify the delimiter (can be a comma, for example).

I hope that is what you are looking for.

Mike.

[mantaq10]

Thanks Mike, this is exactly what i was looking for...:)