change the control souce and it does not update database?

[Yoshie]

I changed the control source on one of my fields so i can prepopulate a
total. So, it shows the total in my form but it does not go to my data base.
How can i fix this?

 

[Beetle]

You likely don't need to "fix" it. With rare exceptions, calculated totals such
as this should not be stored in a table, they are just calculated and
displayed
wherever you need them (i.e. in a form, report or query).