Calculation error ...sometimes

[cbsm]

hello !

this is my very odd problem.

I have a Form (Order Header)
in this form a Subform (Order lines).

In the footer of the Subform - I calculate the number of item and the total amount.
(Sum(Items) and sum(item*price) )
Everything is fine when I create my Order.

The user can also look for old orders.
In this case instead of the result I have #Error in both fields.
If I go through in Debug mode - the result is OK.
I added .repaint, .recalc , .refresh - no effect.
I even tried to put delay to give the "time" for the calculation - no result ...
I checked if any Nulls or stuff like that but no luck.

Any Idea where I could look ?

Many thanks

 

[ssatech]

Have you tried:

"(Sum(Items) and sum(item*price) )"

=Nz(Sum([Items])) and =Nz(Sum([Items]*[Price]))

 

[TheAceMan1]

How are ya cbsm . . .

or perhaps this:

[blue]   =Sum(Nz([Items]))
and
   =Sum(Nz([Items]) * Nz([Price]))[/blue]

See Ya! . . . . . .