Sum function

[magix]

I've got several forms with numbers on them, and I want to put a total of the
numbers on one form. IE:

Form1: $ in toys = 500
Form2: $ in books = 500

And form3 would be Total Amount all together from Form1 & Form2

 

[tina]

if you're wanting to *display* at total on form3, you can use an unbound
textbox control, entering the following in its' ControlSource property, as

=Forms!Form1!NameOfNumberControl + Forms!Form2!NameOfNumberControl

replace both instances of NameOfNumberControl with the correct name of that
control on the corresponding form.

if you're wanting to *store* the total...well, first of all you couldn't
store it in a form, you can only store data in a table. and second, the rule
of thumb is to *not* store calculated data in a table, but rather just
calculate and display it as needed in forms and reports.

hth