Your document uses a mix of content controls (for the dropdowns) and formfields (for the checkboxes). You really shouldn't use content controls and formfields in the same document; they don't work well together and can produce erratic document behaviour.
If you restrict yourself to using just formfields, including for the dropdowns, you can do all the calculations without the need for VBA. You do that by checking each formfield's 'calculate on exit' property, ensuring it has a unique internal bookmark name, then referencing those bookmark names in a formula field that does the tallying. The field code to tally the results would look something like:
{={REF Dropdown1}+{REF Dropdown2}+{REF Dropdown3}+{REF Dropdown4}+{REF Dropdown4} \# 0}
where Dropdown1, etc. are the Dropdown's internal bookmark names.
With content controls, however, you will need VBA.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|