expression is typed incorrectly.....

[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

 

[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

HELP SOMEONE PLEASE

 

[John W. Vinson]

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.

Try putting the parameter into the query's Parameters. Open the query in
design view; right mouseclick the grey background of the tables and select
Parameters, or use View... Parameters from the menu.

Put [Enter Date to be retrieved] in the left column - copy and paste it from
the criteria, as it must match *exactly*, and specify that it is of Date/Time
type in the right column.

John W. Vinson [MVP]