Form/subforms/adding values

[jeo]

I have a form on which I have 3 subforms based on separate queries.
I have some totals on each of those subforms that I would like to add together. I created a unbound control and I tried to add up values from subfoms and it's saying "#Name?"
Not sure what I'm doing wrong...or can these values be added up?
Thanks.

 

[le888]

If you want the total in the main form, then try this :

1) Refere all the values into the main form, i. e. created three unbounded text boxes which each one referes to the value of each values on the subform

2) Created an unbounded text box and add to the
"Control Source" = txtbox1 + txtbox2 + txtbox3

Hope this help.

Le

 

[jeo]

When I try and create an unbound control and assign a value from my subform, it's still saying #Name?
What I'm doing is creating a text box on the main form, and then I tie in the value from subform to tex teboxs' control source.
Is there something wrong with that?
I tried this both ways, with refencing a from =Forms!value1 and without: = value1.

 

[le888]

In your unbounded text box the "Control Source" in the main form:

=[sub form Name].Forms![text box name in the sub form]

or another way to refere the right syntaxe is : go directly to the unbounded text box and then go to the " Control Source". Click on the three little point " ...". Click on generation expression. Click on the Main form Name, then click on the sub form name and then on the text box name. This will give the same syntaxe as I wrote previously.


Le

 

[jeo]

That helped! Previously I was clicking just on the subform itself, without going through the main form first!
Thanks so much for all your help!

 

[kaveman]

Moving this value into a table

Once you get this value how can it be added into a table. Say i have txtBox1 + txtBox2 in my control source and I want this value to show up on my form as well as on a table. Do I need to add something else to the control source?

 

[le888]

I don't know how to do this. I think you have to start a new thread on this but not sure...

Le