#Error in Main Form Text Box

1starr

Registered User.
Local time
Today, 08:04
Joined
Feb 25, 2002
Messages
29
I have three subforms on my main form and because there is no data in one of the subforms I get a #Error message in my text box. Here is the formula that I am using"=IIf([subActiveCallingCards].[Form].[HasData]=True,[subActiveCallingCards].[Form]![text6],0)+ IIf([subSpareCallingCards].[Form].[HasData]=True,[subSpareCallingCards].[Form]![Text6],0)+ IIF([subSuspendedCallingCards].[Form].[HasData]=True,[subSuspendedCallingCards].[Form]![text6],0)". I have tried other ways of putting this formula in and did get this "#Name?" back but that wasn't a good hint of what the solution is. I need all the help I can get, thank you.
 
You don't say which version of Access you're using, and I've only got A97 to hand, but I don't think (despite what the help says) that HasData is a (sub)form property. It works fine with reports, but it doesn't ssem to work with forms at all.

Simon
 
I'm using MS Access 2000.
 

Users who are viewing this thread

Back
Top Bottom