L
Lamar
I have database where several subforms are based on a query (the subforms
are on different forms). When I open any the forms with a subform that is
based on a query, sometimes I get the dreaded "This Expression is typed
incorrectly or too complex...". I emphasize SOMETIMES because about 75% of
the time there is no problem when I open the forms (the query runs fine).
To make things most baffling, I have a different database that has some of
the same forms, subforms and queries. I never have any problem with this
database.
Any idea what the problem is? I have tried to repair the database, import
objects from the good database but it does not solve the problem.
are on different forms). When I open any the forms with a subform that is
based on a query, sometimes I get the dreaded "This Expression is typed
incorrectly or too complex...". I emphasize SOMETIMES because about 75% of
the time there is no problem when I open the forms (the query runs fine).
To make things most baffling, I have a different database that has some of
the same forms, subforms and queries. I never have any problem with this
database.
Any idea what the problem is? I have tried to repair the database, import
objects from the good database but it does not solve the problem.