Intermittent error message in Access 2002

[Guest]

We're using a custom order management program built on Access to enter orders, customer info, etc. When I am at the screen to view orders and I click the button to go to the next order, I get the following error message:

"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.

After getting this message 3 or 4 times, Access shuts down. The weird part is that it only happens every few days for a couple of hours, and then it disappears as mysteriously as it appears. I hope someone can help..... Please email if you have any suggestions!!!!!

 

[GVaught]

This error usually happens when there is an incorrect query constructed
against a form. What you need to do is determine if the form you are using
is based on a query vs the table? If there is a query, is their two or more
tables used? If Yes, then this is where the problem lies. A form should be
based on one table. If you use two or more tables, then you run the risk of
creating an un-updatable form or introduce your current problem. Simplify
the form. If you need to perform calculations, this usually can be performed
on the form itself and not stored.

It may also require you to take a look at your table structure. Are your
tables normalized? Are they setup into relationships?

We're using a custom order management program built on Access to enter

orders, customer info, etc. When I am at the screen to view orders and I
click the button to go to the next order, I get the following error message:

"This expression is typed incorrectly, or it is too complex to be

evaluated. For example, a numeric expression may contain too many
complicated elements. Try simplifying the expression by assigning parts of
the expression to variables."

After getting this message 3 or 4 times, Access shuts down. The weird part

is that it only happens every few days for a couple of hours, and then it
disappears as mysteriously as it appears. I hope someone can help.....
Please email if you have any suggestions!!!!!