SubForm Beginners Help

SubForm Beginners Help

Post by Joe Spence » Thu, 07 Jul 2005 19:18:59


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
 
 
 

SubForm Beginners Help

Post by Joe Spence » Thu, 07 Jul 2005 20:16:17

Did the same with the New Form Wizard and it worked....

Thanks,
Joe