Type mismatch - adding yes/no to form

[lacey]

All,

I have a form that I am trying to add some yes/no fields to from my table. Whenever I add the controls to the form and attempt to open the form in form view, I receive the dreaded error: "Type mismatch in expression." I can't figure out what is causing this error, or where to look.

Attached is my relationships report. The yes/no fields I am attempting to add are located in tblRelationshipToBICs, tblIndustryClassification, and tblTypeOfBusiness. All of the fields (except pk) in those three tables are yes/no and I need to add them to my form.

Let me know if I can provide further clarification or information. Thanks in advance.

View attachment Report1.pdf

 

[Mihail]

The relationships has nothing to do with this error message.
As an advice, enforce referential integrity for the relations between tables.

So:

The yes/no fields I am attempting to add are located in tblRelationshipToBICs, tblIndustryClassification, and tblTypeOfBusiness

How you establish the control source for each control ? (I assume that the controls are check boxes)
If the form is bounded to a table, it is bounded only to a SINGLE table but you attempt to add "fields" from 3 tables. This is NOT possible.
If the form is bounded to a query you must have this fields in the query and "add" this fields from this query.

You can use unbounded controls in order to see the information from other tables (using some code in order to update the controls) but the information in that tables will not be updated if you change the control value (check or uncheck the check box).

So, better is to explain us EXACTLY what you have and what you expect to obtain.

Cheers !