Subform to main form calculation

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

I can't get the data in my subform to calculate in my main form. Here's my
formula

=Sum(TradeInfo.Form!AmountofGain)

Any ideas?

Thanks in advance,
Tony
 
Tony,

If I understand you correctly, I think you need to put an unbound
textbox in the Form Footer section of the subform, with Control Source
set to =Sum([AmountOfGain]) then name this textbox, let's say it is
TotalGain and then the Control Source expression in the main form
textbox will be =[TradeInfo]![TotalGain]
 
Back
Top