How to get the possible value from list box

[#1]

Hi all,

Here I want to get 102 from ID field.

Is any way to solve this?

Thanks in advance..  

Regards,

Kabilan K.

[Gethyn]

HI Kabilan,

Create a macro like this one:

Sub SelectPossibleID()

  Dim strvID

  Set vID = ActiveDocument.Fields("ID").GetPossibleValues

  strvID = vID.item(i).Text

End Sub

Then set a sheet trigger to run the macro on selecting a value in the Name field. This will then write the possible value from the ID field to a variable named strvID.

Hope this helps,

Gethyn.

[jonathandienst · Accepted solution]

Hi

You can do this in an expression (for example, in a text box) with

     =Concat(ID, ',')

This will return a comma separated list of possible values for ID.

Regards

Jonathan

[#4]

Hi Gethyn,

I have a doubt.

In that macro, we have variable called StrvID and How to get this variable in text object and (Expression dialog box)?

Regards,

Kabilan K.

[Gethyn]

Hi Kabilan,

You can show the value in a text box by typing =strvID as the value in the text box.

Thanks,

Gethyn.

[#6]

Hi Gethyn,

I wrote the macro and applied in fileld event trigger for Name field.

But I am not able to see  that variable ( =strvID) in variable list.

Regards,

Kabilan K.