Auto-populate field in Word 2007

S

ssprat

I have a form built in Word 2007. I have one field that contains a drop-down
list. I would like to auto-populate 3 other fields based on the user's choice
from the drop-down list. (i.e. I have a table with 4 columns, the drop-down
contains the records from the 1st colum and the fields I want to
auto-populate is from the associated columns 2-4)
I understand that I will need to run a macro, I am just not sure how to go
about this.

Anything will help. Thanks!
 
J

Jay Freedman

I have a form built in Word 2007. I have one field that contains a drop-down
list. I would like to auto-populate 3 other fields based on the user's choice
from the drop-down list. (i.e. I have a table with 4 columns, the drop-down
contains the records from the 1st colum and the fields I want to
auto-populate is from the associated columns 2-4)
I understand that I will need to run a macro, I am just not sure how to go
about this.

Anything will help. Thanks!

See http://gregmaxey.mvps.org/Linked_DropDown_Fields.htm.
 
M

macropod

Hi ssprat,

If you check the 'Calculate on exit' property for your formfield and make sure it has a unique bookmark name, you can use a
cross-reference field coded as:
{REF DropDown1}
where 'DropDown1' is the bookmark name, wherever you want the field value replicated. No vba needed.

Note: You can create the field via Insert|Field, and filling in the bookmark name, via Insert|Cross Reference and choosing the
bookmark, or by pressing Ctrl-F9 and typing 'REF DropDown1' between the field braces.

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top