Access 2003
I posted this last week; unfortunately, none of the suggested
solutions cured the problem
I have a subform which lists financial transactions for a client in
the main form, which I total in a textbox named "txtTotalPremium" in
the subform footer with the Control Source "=Sum([PremiumGBP])";
without quotations of course. This works fine until the subform has
no records to return, in which case textbox result is blank. That
would be fine except I need to use the result in another text box on
the main form as part of another calculation. I have tried what seems
like a hundred different combinations of the Nz and IIf functions all
to no avail. It seems to me that the straight forward
"=Nz(Sum([PremiumGBP]),0)" should do it, but unfortunately not;
whatever I do I get a blank textbox and "#Error" in the mainform
textbox, Where do I go from here?
As an afterthought. Should it matter that the Subform is on a Tab
Control?
