Forms and Total Sums

[Micky]

Hey,
I'm building a database for Toystore (for my studying).


My question is: I built a form "Invoice". I used the Form Wizard to create this.
The thing is that I need to get the total of the invoice and access doesn't allow me to do this in the same form.
So I thought that it's possible to create another related form and embed the "Total" form into the "Invoice".
I thought that I succeed but than discovered that because the "Invoice" form is not related to the "Total" so, it doesn't show the total of each invoice but the total of the first invoice only, and than you can navigate.
Do yo have any suggestions?

Thanks a lot for helping me.

[Bob Fitz]

The thing is that I need to get the total of the invoice and access doesn't allow me to do this in the same form.

Actually I think this can and usually is done in the same form.
Create a textbox in the form's footer section.
Set the texbox's Control Source property to something like:

=Sum([Put the name of the cotrol that is in the detail section between these square brackets])

[Micky]

Hey Bob, I've added an additional post since I didn't know how to attach a file when I reply.
Please see this: https://www.accessforums.net/showthr...al-sum-example

Thanks!