Assigning a total dollar value to check boxes, when each of 4 check boxes is worth $25.00

[jmare]

On the attached you will notice the line "Total Yearly Fees Owed". Then next to it are 4 check boxes with 9th, 10th, 11th, 12th next to it. Each of these check boxes are worth $25.00. So each time one is checked it would add $25.00 for up to a total of $100.00 over the 4 years in the "Total Yearly Fees Owed" box, or subtract $25.00 for each year that is unchecked/paid. I have gotten all my formulas to add up but I cannot get this to work. I would greatly appreciate some assistance. I have attached my sample page. Thanks!

[Gicu]

For the TotalFeesOwed textbox control source enter =IIF([9th]=True,25,0)+IIF([10th]=True,25,0)+IIF([11th]=True,25,0)+IIF([12th]=True,25,0) or do that in the query that acts as the record source for the form or report. Note the that for the control source you need to use the checkboxes control names, for the query the corresponding field names.

Cheers,

[Bob Fitz]

On the attached you will notice the line "Total Yearly Fees Owed". Then next to it are 4 check boxes with 9th, 10th, 11th, 12th next to it. Each of these check boxes are worth $25.00. So each time one is checked it would add $25.00 for up to a total of $100.00 over the 4 years in the "Total Yearly Fees Owed" box, or subtract $25.00 for each year that is unchecked/paid. I have gotten all my formulas to add up but I cannot get this to work. I would greatly appreciate some assistance. I have attached my sample page. Thanks!

I think you would be better to post a copy of the db. I'm guessing that it's not normalised and that you have bound the "Total Yearly Fees Owed" to a field in a table which, IMHO, it shouldn't be because it si a calculation.