This expression is typed incorrectly ... 1

[ksbigfoot]

I am using MS Access 2000
I am loading a form that contains 2 subforms.
If I remove the second subform, it loads correctly, so I am assuming that it is my second subform that is giving me the grief.

Here is the message I get when I load the subform

This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."

If I step through the code, I don't get an error message.
My subform Link Master Fields is based off of a hidden text box that is on the main form.

Can someone point me in the right direction?
I am stumped on how to fix this.

 

[genomon]

Have a look at the source query. It probably has a defined field(s) with a bunch of nested IIfs or something. We had to rewrite a bunch when we migrated to 2000 from 97.

"Business conventions are important because they demonstrate how many people a company can operate without."

 

[ksbigfoot]

Howdy genomon,
Thanks for the post.
I have a very simple query that has no iifs

Which has led me to the way my subform is linked to the hidden text box. I just did a quick test and If I default my hidden text box to 0 (zero), then it works, but if I had an empty string in there, then it was erroring out. After reading my post, I should of mentioned that my tables were linking to SQL Server. SQL Server must not dealt with empty string or Nulls very well.

I gave you a star as it did point me away from my query.

Thanks again for the post.
ksbigfoot