Adding values in a form then putting it in a table HELP

[Beau]

Hey there, Im currently making a form so users can enter project information. For this particular project, the user must choose from a variety of options, and each option has a number value assigned to it for a rating. Now at the end of this form, I want a sum of the ratings, and then entered into the table. I am using a text box for the sum of ratings, and can get the sum of ratings to work on the form, but this data is entered as a 0 in the table. If anyone could help me find a way to put the actual sum in the table, that would be excellent.. thx a lot.

If it would be any help, here are the names of text boxes that I'm adding:

Health and Safety Rating, Maintenance Rating, Equipment Rating, School Size Rating, Student Enrollment Rating, SD Priority Rating, Project Requested Previously Rating

Those ratings must be added into "Total Rating"

Thankyou!

 

[ScottGem]

Now at the end of this form, I want a sum of the ratings, and then entered into the table.

Um no. As a general rule we do NOT store calculated values in a table. There is no need to do so, since they can be calculated on the fly where needed. You can use the same expression you now have as the controlsource for the Total Rating control on your form either in a report or in a query.