Populate one field based on value of another

[Robert_L_Ross]

Here's my question...

I want to populate Field2 based on the vaule in Field1. Field1 is a
dropdown box. If I select a specific value from that box, I want a macro to
detect the value and populate Field2, a text field.

I can't seem to find the right command in VB. Any help?!

thx!

 

[Greg Maxey]

Robert,

Assuming your dropdown is named dropdown1 and your formfield2 is named text1
then something like:

Sub PopulateField()
Dim myVar As String
myVar = ActiveDocument.FormFields("DropDown1").Result
ActiveDocument.FormFields("Text1").Result = myVar
End Sub

Run as an on exit macro form dropdown1 should do.

 

[Graham Mayor]

See http://www.gmayor.com/SelectFile.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>