My problem is I need to subtract the TotalAmountRecoup (Subform)from the TotalServAmountPaid (Main form), but it is only giving me the TotalServAmountPaid, which is what is calculated from the Main Form.
I have a situation where I have four (4) TABLES and only two of them have a unique field.
Main form uses TABLE 1 and TABLE 2
Table 1 Fields
IDNo = Keyfield
Table 2 Fields
TABLE 1 is linked to TABLE 2 by IDNo (keyfield)
There are many different IDNo for a ReferName, and ReferName is not a unique field in TABLE 1
The Subform Property Sheet (frmRecoup) = Link Master Fields by TransNo from TABLE 2,
Link Child Field TransNo from TABLE 3.
The Subform uses TABLE 3, and TABLE 4 to link the TransNo to each other, TABLE 3
Table 3 Fields
TransNo – Keyfield
Table 4 Fields
My problem is that the Main form which is linked to TABLE 1, by IDNo has many IDNo for a ReferName.
I created a calculated field in the Main form to calculate the total ServAmountPaid by TransNo from TABLE 2, and I created calculated field in the footer of the Subform to calculate the total AmtRecoup. I named the calculated field TotalAmountRecoup, and named the calculated field on the Main form TotalServAmountPaid.