Subtotal from subform seen on main form but also stored in the Orders table

[accessbuddy]

I have a subform (frmOrders_Lines_sub) in a main form (frmOrders). The subform has a many dropdowns for all my various materials etc for an order. The unit quantity is then multiplied by each unit price to provide a subtotal. However I want to have this subtotal in the main form and STORE it in the Orders table! I have tried to do a calculated field but this does not work. Are they any other options please?

[Bob Fitz]

You should be able to display the total in a text box on the main form by setting the text box Control source property to reference the text box on the sub form. Something like:
= Forms!frmOrders.NameOfSubFormControl.Form.NameOfTextBox
I do not think you should be storing the calculation. That should be calculated whenever and wherever it is needed.