View Single Post
 
Old 09-03-2015, 11:07 PM
Guessed's Avatar
Guessed Guessed is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,164
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Assuming you have three checkboxes to test your code might work along these lines
Code:
Sub SetCheck()
  Dim bChecked As Boolean
  bChecked = False
  With ActiveDocument
    If .FormFields("Check1").CheckBox.Value Then bChecked = True
    If .FormFields("Check2").CheckBox.Value Then bChecked = True
    If .FormFields("Check3").CheckBox.Value Then bChecked = True
    .FormFields("Check4").CheckBox.Value = bChecked
  End With
End Sub
Assign the macro to run on exit for each of the formfields that trigger the summary checkbox.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote