Access 03 Control Source Help

[Mystafet]

OK, so I have a form, that is linked to a table. I have numerous fields (Yes/No) that have values associated with them.

I changed the Control Source of the TOTAL field on the form to:
=[Q1 Value]+[Q2 Value]+[Q3 Value]+[Q4 Value]+[Q5 Value]+[Q6 Value]+[Q7 Value]+[BPO Range Value]

This is adding the value of all the fields associated a value to them. However, I need this value linked back to the table field [BPO Score].

Is there a way I can set the control source on the form to still do the calculation, but also show up on the table field [BPO Score]?

If there is not a way to do that, are there any other alternatives to still have all the fields calculated and then show up on the table itself?

I'm not really savy with access, and do not know SQL, any help would be greatly appreciated.

 

[Mystafet]

I have been searching, and have seen that if I make the calc a hidden text box, and have VB code to update the [BPO Score] field using a macro.

The problem is, I need it to update the [BPO Score] field when the value in the hidden calc field changes.

The ON CHANGE, BEFORE UPDATE, and AFTER UPDATE all did not work to update the field associated with the table once the other feidl changed.

Text108 = BPO_Score

 

[Joe4]

Why do you need/want it to update a field back in the table?

In general, it is not a good idea to "hard-code" a value which is the direct result of a calculation from other fields. It can undermine your data integrity (if you change one of the underlying vales, the total may not be updated).

Usually, what you want to do is perform the calculation in a query. You can then use the query as the control source of your form instead of the table.