Hey, I have a problem I have been working on for a little while now. I have a form in progress which has two subforms. The goal of the form is to be a Bill of materials. The first subform is for the prices and quantities of parts in an order, the second is for the labor hours and total labor costs in an order.
I am trying to make a calculation in a text box in the main form that calculates the subtotal of the extended costs of the parts, and a total that sums up the previous subtotal with the total in labor costs.
This is the equation I have been fiddling with in the main form to achieve the first calculation:
=[Forms]![BOM1]![Parts per order Subform]![SellSubtotal:]
Which is referencing the subtotal equation in the 'Parts per order Subform' that is in the footer. The problem is that this subform has to remain in table view.
Please help!
I have also tried methods similar to:
=Sum([Forms]![BOM1]![Parts per order Subform]![Quantity]*[Forms]![BOM1]![Parts per order Subform]![PartCost])
Resulting in only a #error message
Sorry for wasting any time if I did, this issue was solved. I had to be referencing the text block itself, not what I 'declared' it. Haha, right under my nose