I am making a basic CRM style database with a table for Accounts and a
table for Contacts.
I have created a form for the Accounts table with a subform of the
If there is data in the Contacts table, when i open the Accounts form I get
the following error.
"This expression is typed incorrectly, or 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
I have set a one-to-many relationship between accountID in the Accounts
table and AccountID in the Contacts table. AccountID in Accounts is
Autonumber and AccountID in Contacts is a number.
I can't see what I've done wrong.