Adding Up Subform

  • Thread starter Thread starter phuser
  • Start date Start date
P

phuser

the Subform contains data that is to be summed up on the main Form

I have a text box on the Main form =UnitRepairsSubform.Form!Labor

I tried to change it to =[UnitRepairsSubform].Form!Labor but everytime I try
to save it the [ ] go away

All that appears in the text box is the 1st line in the subform, nothing
adds up

Any help would be greatly appreciated
 
Add a textbox to the footer of a subform. Name it txtTotal. Set its height
to 0" and hide it by putting it on the edge of the footer. Set its
controlsource to:

= Sum([Labor])

Set the footer to 0" height as well.

Now add a textbox to the main form and set its controlsource to:

= Forms!MainFormName!SubformControlName.Form!txtTotal
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Your the Best Thanks!!

Arvin Meyer said:
Add a textbox to the footer of a subform. Name it txtTotal. Set its height
to 0" and hide it by putting it on the edge of the footer. Set its
controlsource to:

= Sum([Labor])

Set the footer to 0" height as well.

Now add a textbox to the main form and set its controlsource to:

= Forms!MainFormName!SubformControlName.Form!txtTotal
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

phuser said:
the Subform contains data that is to be summed up on the main Form

I have a text box on the Main form =UnitRepairsSubform.Form!Labor

I tried to change it to =[UnitRepairsSubform].Form!Labor but everytime I try
to save it the [ ] go away

All that appears in the text box is the 1st line in the subform, nothing
adds up

Any help would be greatly appreciated
Click to expand...
Click to expand...
 
Back
Top