View Single Post
 
Old 02-05-2016, 10:29 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

When I use the Excellent/Very Good/Good/Below Average/Poor dropdowns, their calculations update as soon as the dropdowns are exited, whether that's by tabbing or via the mouse. There is no field coding associated with the 'action required' dropdowns, so nothing can be expected from them. Do note that formfields only work when the document has 'filling in forms' protection applied.

I also note that you've duplicated the calculation fields every time you want to refer to the same dropdown. That is not necessary. Simply bookmark the first set of calculation fields for a given dropdown then reference that bookmark for the other instances.

For example, for dropdown c1, you might bookmark the field coded as:
{={IF{REF c1}= "Choose an item." 0 {IF{REF c1}= "Excellent" 1 {IF{REF c1}= "Very Good" 2 {IF{REF c1}= "Good" 3 {IF{REF c1}= "Below Average" 4 {IF{REF c1}= "Poor" 5 0}}}}}}}
with the name 'c1Score'. Then, wherever else you want that score to appear, simply insert a cross-reference to 'c1Score'. That will make your form easier to maintain and should also give a smaller file size.

There is also no point in saving the document in the .docm format. It contains no macros, so should be saved in the .doc or .docx formats.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote