471,337 Members | 1,054 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

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

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.

Dec 10 '06 #1
2 2214
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)
Dec 11 '06 #2
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)
Dec 11 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by William Wisnieski | last post: by
2 posts views Thread by chris vettese | last post: by
9 posts views Thread by William Wisnieski | last post: by
3 posts views Thread by William Wisnieski | last post: by
2 posts views Thread by Michelle | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.