Update field when checkbox selected

[dmadsen11]

First... I am absolutely new to VBA programming, but I have done quite a bit of programming in AutoLisp. What I want to accomplish is to update a field (formatted as currency) to add a set dollar value to the current value of the field if a checkbox is selected. I have a series of 12 checkboxes in a form, and if one or more of them are selected or de-selected, I want the TOTAL field to update accordingly.

Any help is greatly appreciated!

Thanks,
Dave

 

[straybullet]

Perhaps on AfterUpdate of each checkbox:

If Me.NameOfCheckbox then
Me.NameOfTextBox = Me.NameOfTextBox + DollarAmount
Else
Me.NameOfTextBox = Me.NameOfTextBox - DollarAmount
End If

Let them hate - so long as they fear... Lucius Accius