Forms and total sum- example

[Micky]

I'm adding a new post, since I couldn't attach the file when I reply for some reason (or I didn't know how).


I'm here attaching a print screen of the form, I would like to sum up the total sums in the Subform. How do I do this?


Thanks for your reply.

[Bob Fitz]

In your first post ( https://www.accessforums.net/showthr...027#post114027 ) you didn't mention a subform or that it is being used in datasheet view. Footer sections of a form can not been seen when the form is viewed as a datasheet but they are still there. Carry out the instructions I gave in your other post to create a textbox in the footer of the subform. Create another textbox in the main form and set it's Control Source property to the textbox in the footer of the subform. Something like:
=Forms![NameOfMainForm]![NameOfSubform].Form![NameOfTextboxInFooter]

[Bob Fitz]

You could also use this:
=Me]![NameOfSubform].Form![NameOfTextboxInFooter]

[Micky]

I have somehow succeed but in a different way, by using Macro.
Thank you very much for your support.