Subform grandtotal link to table

[Guest]

In my form I have a subform (LineItems) that displays line items from a
table, such as part number description cost and sell. In this subform there
are two field that calculates the subtotal for the cost and sell.
In this same form I have another subform (QQsubform) that is linked to a
different table and it displays totals based on the project. I have to
manually fill in all the information in this form. How can I link or update
the subtotal QQsubform to the subtotals from the LineItems subform? Can
anyone please help?

 

[Steve Schapel]

Gerry,

If I understand you correctly... Put an unbound textbox on the main
form, set its Visible property to No, and set its Control Source to the
equivalent of:
=[LineItems]![YourSubTotal]
Let's say you name this textbox LineRef. Therefore, in the QQsubform,
you can refer to the value by:
=[Parent]![LineRef]