Same calculated field on two forms

[Guest]

I have a calculated field, (sum,) derived from subtotals on three subforms
that appears on a form. I need to display this same total on another form,
(same record number,) where I'll be using it in another calculation. I have
been thus far unsuccessful in doing this. Any ideas?

 

[MacDermott]

Is your original form open at the time you need to display this value on
your second form?

 

[John Vinson]

I have a calculated field, (sum,) derived from subtotals on three subforms
that appears on a form. I need to display this same total on another form,
(same record number,) where I'll be using it in another calculation. I have
been thus far unsuccessful in doing this. Any ideas?

I'd suggest using the DSum() function to sum the values directly from
the Table, as a calculated field in a query; base your second form on
this query. Or use the DSum() experession as the control source of a
textbox on the form.

John W. Vinson[MVP]

 

[Guest]

No. The totals are calculated in the Procurement form. The P&L manager sees
these on his form when he opens that record. Kind of an overview.