display sum from subform to mainform

[Revned]

I have a subform qryOrder subform under
Form footer I have a txtTotal that sum the order amount field
i want to display the result in main form how to accomplish it?

thanks anyway

[Tom Wickerath]

Hi Revned,

Try this tutorial:
Displaying Subtotals and a Grand Total on a Form
That Displays a One-to-Many Relationship
http://www.access.qbuilt.com/html/subtotals.html

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

[Revned]

Hi, Tom Wickerath

this what i deed as what i understand from the example
I make a textbos under the subform Form Footer
with a contro sourcer =sum([Amount])

I have this syntax in my main form
=[qryOrder subform].txtTotal

but still no result is being display

i also try doing
=[qryOrder subform].[frmOrders]!txtTotal

but still no luck

what else do I miss here???

thanks

[Tom Wickerath]

Hi Revned,

> this what i did as what i understand from the example
> I make a textbox under the subform Form Footer
> with a control source =sum([Amount])

Open this form by itself (ie. not as a subform), in continuous view (or form
view), but not in datasheet view. Do you see a sum correctly calculated? What
I'm asking you to verify is that you see a total similar to that shown in
Figure 4 of my tutorial.

> I have this syntax in my main form
> =[qryOrder subform].txtTotal
>
> but still no result is being display
>
> i also try doing
> =[qryOrder subform].[frmOrders]!txtTotal

But neither of these forms that you tried are correct. You need something
like this:

=[NameOfSubformObject].[Form]![NameOfTextboxInSubform]

If the name of the control that holds your subform is "qryOrder subform",
then you need to use this:

=[qryOrder subform].[Form]![txtTotal]

Note: The .[Form]! part shown in the middle will never change. It has to
be exactly this, *not* the name of the form.

[Revned]

Yes thank you Tom Wickerath it works good now...

but the problem is how to avoid #Error when the Amount = 0??

thanks again

[Tom Wickerath]

If the amount is equal to zero, you shouldn't get an error, since 0 is a
valid number. Did you possibly mean that you are getting an error with nulls?

If so, try this:

=sum(Nz([Amount], 0))

[Revned]

Sorry this what I mean

I have a cmbName and subform frmOrdersubfrom i my main form
I have #Error result from txtAmount when no records are selected
from the cmbName...

is there a way to handle this??

thanks again

"Tom Wickerath" wrote:

[Tom Wickerath]

Sorry about the late reply. Without seeing a copy of your database, it is
really hard to say what is causing this error. Have a look at this KB article
to see if it is helpful:

Troubleshooting Tips for Error Values
http://support.microsoft.com/kb/209132

Note: Disregard the "ACC2000" in the title.