Same calculated field on two forms

B

Bryan

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?
 
M

MacDermott

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

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?
Click to expand...

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]
 
B

Bryan

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.
 
Top