Form Summation Help

I have what is basically an order form that I am working with. I did not create the form, and I would rate my MS Access knowledge as Intermediate, I do not know VB. The way the form works is that you click a radio button to select the item(s) that you want then you click a submit button at which point a table gets appended.
What I am trying to do is to have a price field that gets update when the radio button is clicked that takes (order quantity * unit cost) to show the total cost for that line and then to sum all of the lines into one field for a total order cost.

Any help is appreciated.
Thanks

re: Form Summation Help

I don't imagine anyone will be able to help much without some sort of description of the data you're working with. What are the tables called? Which tables are used in the form (I'm assuming just the one form so far)?

re: Form Summation Help

Nope, lots of tables and forms.
I can post whatever is needed.

re: Form Summation Help

I suggest you post the details of the tables and forms related to this question then. We don't need everything, but if there's anything that we will need to understand the question properly then you can be sure we'll need it.

As only you know what those details are then you must determine what's required. Generally relevant field and control names are required, as well as which objects they are related to.

Basically, it all goes along much more easily if you get this part right. It helps us to help you. We all win.