Type Mismatch Expression error

[Penny Crowe]

Trying to create a form that takes info from Address List table and Family Member Table and puts the information together. Address List table contains First Name, Last Name, Address, City, State, Zip as well as an ID number and Family Identifier number. Family Member table has same ID number and Family Identifier number as Address Table, as well as First Name, Last Name, Gender, Relationship, Birthdate. When I created a subform to put the names of the children/spouse on the Family Members record, I got the Type Mismatch Expression error. I used the ID number as the primary key in both tables and used the ID as the relationship identifier. When I try to view the form I get the error message, and then the subform is blank. Would appreciate any insight I can get asap as this is for my final project in a class. Thanks!

Penny Crowe:banghead:

 

[burrina]

You may be trying to put a text type into a numeric type..
Check all your types and make sure they are compatible..
I would suspect that you have your relationships incorrect as well?