#Error in Main Form Text Box 1

[1starr]

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.

 

[jhall156]

An easy way to test your syntax is to open a module and paste the expression preceded by ? into the immediate window and hit return JHall

 

[1starr]

I try that and it didn't solve my problem.

 

[jhall156]

I didn't say it would solve your problem but that it might help diagnose it. What was the system's response to your command? JHall

 

[1starr]

I got a complie error - Expected:expression

 

[jhall156]

If you'd like, you can email the .mdb to me at jhall@worthltd.com JHall