Unanswered: Summing Text boxes from different subforms
I am trying to display the total price of a quote. I have several subforms which adds up the subtotal in the footer. i used =Sum([Sub_parts]) for example to add up all my parts and in another subform =Sum([Labor])
I would like to add all the subtotals to display a total price.
I have managed to pickup one of the subtotals by using the following code in the Control Source property =frm_sub_parts.Form!Parts_Subtotal and this appears to work fine. I would like to add the remaining subtotal but don't know how?