Linking fields

[Guest]

Is it possible to link the selection in a dropdown to a specific response in
another field.

I have a letter that has a signature block with 5 different peoples names.
What i want to do is have the form automatically insert that persons title
and phone number (based on the name they select in the dropdown) in the
signature block.
ie:
Joe Blow
Administration Manager
Ext: 1234

Paul

 

[Doug Robbins - Word MVP]

Create the title and phone number as an autotext entry for each signatory
and then use the following:

' Macro created 15-11-97 by Doug Robbins to add the address corresponding to
a drop down name

'

Set myDrop = ActiveDocument.FormFields("Dropdown1").DropDown

Company = myDrop.ListEntries(myDrop.Value).Name

Address = ActiveDocument.AttachedTemplate.AutoTextEntries(Company).Value

ActiveDocument.FormFields("Text1").Result = Address


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Guest]

Sorry Doug, I am not understanding your instructions - can you please explain
it again.