from 2003 to 2007 the iff statement

[Pedro]

in access 2003, the statement: =IIf([Accounts
Subform].Form.RecordsetClone.RecordCount=0,0,[Accounts Subform].Form!Balance)
worked just fine.... when I converted to access 2007, I get: #Name ?
I'm not a programmer, but I was using a template to keep my accounts balance:
what happened from 2003 to 2007?

 

[Alex Dybenko]

Hi,
perhaps this is a reference problem:
http://accessblog.net/2006/05/how-to-deal-with-missing-references.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com