I have a subform with line items where the extprice field is a calculation of two fields. I have this calculation in the control source of the extprice field:


This works fine to display the information but I would really like to save it to the table. I then place the above information into the default value and changed the control source to the field extprice. However, the field does not display the default value.

I would also like to know if I could display the total value of the line items at the bottom of the form when the field is not saved to a table and is only displaying the information.

Any help is appreciated.