Form auto fill based on a different field value.

stct · #3 03-22-2013, 06:58 AM

Hi Macropod,
Thank you for the prompt response. I think, the requirements are the same as depicted by you. Unfortunately, I am unable to see the dynamic value changing into Code and Location field, after changing the value in Dept (Dropdown1) field.

Any advise if I need to configure the word document setup? I do see the IF statement correctly. Just that, it is not populating with the values after protecting the document.

Please advise.

Thank you!

Quote:

Originally Posted by macropod

Hi stct,

See attached. The document uses a dropdown formfield for the predefined values, and formula fields for the variable output. If you unprotect the document and press Alt-F9, you'll be able to see the formula field contents.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MACRO - Insert row based on Form Field Criteria	Elan05	Word VBA	5	04-16-2013 06:39 AM
Nested if field that contains a fill-in field is not prompting for fill-in info	Nccadm	Mail Merge	2	04-02-2013 03:15 AM
Form file timesheet, auto fill date from calander	jkeeney	Word	1	03-21-2012 12:21 AM
Macro to populate a text form field based on dropdown selection	koloa	Word	0	10-20-2011 11:52 AM
How can I fill in form I received in email that used underlines instead of text field	Gail L.	Word	2	05-17-2009 12:38 PM