Sum of a field of a subform on a Main Form !

[prakashwadhwani]

I have a (Main) form named : Stocks_Main
and a Subform in that named: Stocks_Data

The Subform is a continuous form
There is a field in the subform called QTY_IN

Now ... on the main form i.e. Stocks_Main I have set a text box to
display a total of the QTY_IN control (which is on the subform).

I am using the foll code as the control source for the text box
=Sum(nz(Forms!Stocks_Main!Stocks_Data.Form!QTY_IN) )

but keep getting a #Error
Could someone please correct it for me.

Thx & Best Rgds,
Prakash.

[luanhoxung]

my idea:
create a control(total) on subform with control source: = sum([QTY_IN])
then in control source of text box(mainform) set
= forms!mainform!subform!control_name(total)

[Prakash]

Thx !! I already moved my control from the Main Form into the
Sub-Form.

However I'd still like to get it to work from the Main Form if possible
without the
sum([QTY_IN]) control being on the Sub-Form.

If you or anyone comes up with a solution please drop me a line. I'd
greatly appreciate it.

Thx & Best Rgds,
Prakash.

luanhoxung wrote:

my idea:
create a control(total) on subform with control source: = sum([QTY_IN])
then in control source of text box(mainform) set
= forms!mainform!subform!control_name(total)