Acc97 - #Error with value lookup from subform

[noodnutt]

G'day ppl,

I know this has probably been posted a gazillion times, and in most cases, I
missed the boat:

I have this as my control for my lookup value which is in the form footer:

=Nz([frmViewOrdersByONSub].[Form]![TotalCost])

It works if there is a data population for it to total, but the annoying
#error that appears until the subform is populated is somewhat unattractive,
I know this should display zero's.

I have the default value's of both the subform & the main form control set
the same with zero default values & Nz().

Any ideas, love to hear them.
TIA
Reg's
Mark.

 

[Van T. Dinh]

Try using Nz() in the expression being used as the ControlSource for
[TotalCost] in the Footer of the Subform.

I assume [frmViewOrdersByONSub] is the name of the Subform*CONTROL* which
may or may not be the same as the name of the Form being used as the
Subform.