Total line in a form

[michelangelo]

Hi there

I have to refer to a sum field in a total line of a subform in order to
store the total value in a Table field underneath the main form. The main
form table is different than the subform table. Is it possible? How can I do
it?

Many thanks in advance.

 

[Alex Dybenko]

hi,
you can refer like:

Forms!MainForm!SubFormControlName!Form!txtTotal

But not sure this is a good idea. First of all you do not need to store
total, you can always calculate it using query, and you will always have it
up to date
and if you really need to store it - you can run update query to save total
of underlying records

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com