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

  • Thread starter Thread starter Bob Howard
  • Start date Start date
B

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)
 
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.
 
Back
Top