I have a two subforms within a form and am trying to calculate the a fields for each record in the two subform respectively. I want the totals of these fields to be displayed outside the subforms. For the first subform, I have the following [PaymentAmounts subform].Form![TotalsAB].
For the second subform, I have the following [Settlement subform].Form![TotalExp]as the control source of the control. However, only the amount for the selected record in the subform appears in the total field. How can I have all records appearing in the subform to calculate and shown in the totalAB and TotalExp, respectively.
For the second subform, I have the following [Settlement subform].Form![TotalExp]as the control source of the control. However, only the amount for the selected record in the subform appears in the total field. How can I have all records appearing in the subform to calculate and shown in the totalAB and TotalExp, respectively.