This is just a small thing that deals with field formatting.
I have a SubForm called: subFormReturned
which contains a field in the footer called; txtQReturned
with the datasource of txtQReturned being; =Sum(NZ([Inv_Returned_Qty]))
The field is then displayed on the main form as =([SubFormReturned].[Form]![txtQReturned])
If there is data in this field in the subform it displays correctly on the main form.
If not, I get the #Error indicator.
It does however display correctly on the subform if there is no data, so the NZ is being lost in the translation.
I thought that the NZ in the original field would have made it a happy camper, but not so.
I'd appreciate any suggestions,