Calculated Totals in subforms

[Guest]

I have added a text box in the footer of a subform to total all the line
costs. My subform is a datasheet view, but it does not show the Total Cost.
When I go into design view, my design is there, but when I go into form view
it is no where to be found. Any help would be appreciated.

thanks
Melinda

 

[Joan Wild]

It's a limitation of a datasheet style. You can keep it like that and put a
textbox on the mainform that has a Control Source that references the
textbox on the subform i.e.
=Forms!SubformControlName.Form!TextboxControlName
or you can change the style of your subform to continuous form. That will
show the footer, and you can make a continuous form look very much like a
datasheet.

 

[Guest]

Thanks Joan

It's a limitation of a datasheet style. You can keep it like that and put a
textbox on the mainform that has a Control Source that references the
textbox on the subform i.e.
=Forms!SubformControlName.Form!TextboxControlName
or you can change the style of your subform to continuous form. That will
show the footer, and you can make a continuous form look very much like a
datasheet.