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?