#error appears on form

[Tony Scullion]

Hi Group,

I have a text box, on a datasheet subform, which totals
the amounts that appear in a query. I reference the text
box on my main form like so...

=(Nz([frmSearchFormMeasures].Form![TotalAmount],0))

....it works well but the #error problem occurs when the
datasheet has no records to total and it shows this. As
you can see I've tried to get round it using the Nz
approach but with no luck - can someone help.

Cheers

Tony