How To Display Form Footer Text Box ?

[cheer]

There is one grand total text box in a subform under the form footer. How to display the text box at the subform and after this subform is embedded into a main form at the execution time?

 

[JANR]

Create another textcontrol on your mainform and in it's ControlSource refer to you grandtotal control on your subform.

ex:

=MySubform.Form!GrandTotal

Change the boldparts to match your controlnames.

JR

 

[cheer]

Thanks for the suggestion above, it is one way.

Any chance to show the grand total at the form footer inside the subform at the execution time in a main form ?

 

[JANR]

If the subform is either Single or Continious then Yes if it's datasheet then No.

Just test it.

JR

 

[cheer]

Thanks .............