Query referencing sub-sub-form works in Access 2000 / fails in Access 2003

[Bob Howard]

I had a query containing an iif referencing a text box control on a subform
of a subform of a form. When I execute the SQL under Access 2000, it
properly evaluates to True or False depending on the value in the control.
So far so good.

When testing in Access 2003, the iif always evaluates to False! My
workaround was to create a non-visible text box control on the top level
form and change the query to point to it instead. Just before I execute the
SQL, I copy the value of the control to the copy on the top level form. Now
the iif evaluates properly (regardless of Access version).

I searched the MSKB's zone for Access and Access 2003, but found nothing.

Any clues?

Bob (@Martureo.Org)

 

[Pat Hartman]

I believe that the rules on object referencing have been tightened up in
A2003. Make sure that your reference doesn't leave out any parts. Post it
and someone will look at it and help you.