Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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>
pls attach a qvw file or a snapshot of that to get a clear picture of what exactly you want.
thanks
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.
The right terminology is "Optional" and "Excluded" values....
Is there a way to programmatically get access to them?
NOOb pleads.....:)
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.
Thanks Mike, this is exactly what i was looking for...:)