Formu;las in Access to update a table

I have a form with 3 fields. Each field is from 3 seperate tables. I want to add together the value of two of the fields and update the third field. the third field has an existing value that will be updated with this formula. I have a formula that works on the form, but it doesn’t update the table. How can I make this happen?