T
tecas
Recieving the error message "The expression is typed incorrectly or it
is too complex to be evaluated... " when opening a form based on a
query. The query has a simple date selection where want date = [Enter
Date to be retrieved] and works fine when executed. The Form has a
subform which populates another table different (Metrics) from the one
the query is based off of and uses eight of the fields in the main
form. These fields as well as the others in the subform are updated in
the Metrics table. The error message occurs 50% of the time when
opening the form. I have tried decreasing the link Child and Master
fields from eight to six yet still encountering the same message.
Any thoughts and help would be greatly appreciated.
Thanks,
Ted
is too complex to be evaluated... " when opening a form based on a
query. The query has a simple date selection where want date = [Enter
Date to be retrieved] and works fine when executed. The Form has a
subform which populates another table different (Metrics) from the one
the query is based off of and uses eight of the fields in the main
form. These fields as well as the others in the subform are updated in
the Metrics table. The error message occurs 50% of the time when
opening the form. I have tried decreasing the link Child and Master
fields from eight to six yet still encountering the same message.
Any thoughts and help would be greatly appreciated.
Thanks,
Ted