Adding Records in a Form

[Gootz11]

Hello All,
I have a Form that shows the totals of 5 different queries using a list box to look up the value in the queiries.
I want to now add up the values inside that form. I have done this in the past but i can't remember how. If anyone has any Ideas, Please HELP!

Thanks
JG

 

[Jack Cowley]

Your question is a bit vague but maybe this is what you are after:

Me.Total = Me.Control1 + Me.Control2 + Me.Control3....

hth,
Jack

 

[Gootz11]

Jack,
that's exactly what i was trying to do, however, when I'm getting a "#Name?" Error.
Let me try to be a bit more specific.

Querie 1__C12 Totals=sumoftotal
Querie 2__C10 Totals=sumoftotal
Querie 3__C01 Totals=sumoftotal

Now, my form, using a list box, looks up the values of this 3 queries.
DATA
Control Source.........=[CG C12 TOTALS]![SumOfTOTAL]
Row Source Type.....=Table/Query
Row Source..............=C12 Totals
Bound Column.........=1
and it looks the same for the other 3 list boxes.
this returns the value of each querie which are
5000
7250
9500

now, i want to add a text box to adds up this 3 values, i don't think i been wording the text box correctly and keep getting the "#Name?" Error.
thanks Againg
JG

 

[Jack Cowley]

So you have 3 list boxes with 3 totals in each list box, right? Getting the totals for each list box is not easy. I would suggest that you take the three queries that you use to get a total and add them to another query and then add them together in that query. Either add a subform to display the totals based on the queries or base the form on the 'totals' queries.

I hope that made sense...

Jack

 

[Gootz11]

Yeah, that's what i ended up doing,
thanks for all of your help anyway
JG