SubForm Beginners Help

  • Thread starter Thread starter Joe Spenceley
  • Start date Start date
J

Joe Spenceley

Hi,

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
associated contacts.

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
variables."

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.

Thanks,
Joe
 
Back
Top