Running Total on Form with Subform

[Njliven]

Like to know if this is possible. I have a main form that show the initial price of a job. Then a subform that list all the change orders for that job with those prices. Can I put a calculated field on the main form that add the beginning price and all the change orders from the sub form.

I tried putting this formula in text box =[total].[tbl_PROJECTS]+[$ Amount].[tbl_PROJ_CO] the field only shows #Name? like it is not recognizing the table and field names. Any suggestions.

[Bob Fitz]

Try this:
Create a textbox in the Form Footer of the sub form. Set its Control source property to =Sum(NameOfFieldToSum). Set its Name property to: SFTotal
Create a textbox on the main form. Set its Control source property to: Forms![main form name]![subform control name].Form![SFTotal] + [NameOfControlOnMainFormToBeAdded]