Thanks macropod



This is good information! I have downloaded both documents. Lots of good reference material, but I can't find anything on being able to determine if the field changed or how to change several other fields because this one changed. I think I could see a way to calculate the payment with field texts, but what happens if the user overrides the field that is being calculated?

My initial goal was to populate the dates when this document is created from a template (.dotm or .dotx), all based on the current date, unless that date has a valid date (like when the document is revisited in a follow on edit session.) Word fields are great when doing calculations and format manipulations. I don't see how to use that to set other fields based on the the value of this. I know I can reference a value and use if-then-else to calculate and manipulate the value, but then it is not an enterable field on the form. My initial dates are "suggestions".

IE: If the 1st payment date is changed, I could use a word field to display a last payment date, but don't see how to change the legacy field value for the last payment date.

The functionality you seek is built into Word itself. And, as I clearly said:In a document with 'filling in forms' protection applied - which is required when using formfields - what you describe simply isn't possible unless one breaks the document into Sections and leaves Section containing the formula fields unprotected. In Sections of a document with 'filling in forms' protection applied, only the form fields (not any formula fields or other fields) are accessible for selection or user input.

For a fairly simple demonstration of formfields in action, see: https://www.msofficeforums.com/171152-post2.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I'm a bit confused between field codes {F9, a-F9, & c-F9} and field controls.

I've tried field code several times and rarely get them to work. I tried to calculate the end of the loan term by using the VBA function DateAdd("M", StartDate, nper), where StartDate and nper are numeric Text Form Fields. Can field codes reference these? I tried something like:
{ =DATAADD("m", {REF StartDate }, {REF nper} ) \@ "MM/dd/yyyy" }

But get
!Syntax Error, (

Sooo, instead I did everthing with Legacy Text Form Fields and the Exit field.
What I was initially asking, is there a way in the exit sub to tell if the formfield was actually changed?

My hack was to create Static variables then compare that static var value to the formfield value:
ActiveDocument.FormFields("StartDate").Result
if different, I update other FormFields, then before leaving, copy the current formfield value into the static variable.

This is mostly working but somewhere the static vars are re-initialized (Using the debug.print command)

(My previous message was trying to use field codes instead of formfields exit sub
Ken