got the following error ....????????

[sunshine]

I am trying to create a form with a subform. Everything seemed ok going throught the wizard but when I clicked finish and went to my form there was nothing in my subform. Access has created another form called tableanme subform. When I click on that form, I get the following error: "Type mismatch in JOIN expression" Is there something I'm doing wrong????

Thanks!

 

[Ziggy]

Does your subform have a related field to the main form, and are both data types the same.


The table for the main form may have an autonumber field, and the table for the sub should have just a number field