Yes/No Field

[accessman2]

Hi,

I created 2 different table

Table1:
Datatype:
Field1: Text
Field2: Text
Select: Yes/No

Table2:
Datatype:
Field1: Text
Field2: Text

And then, I create a query to match up the fields of the 2 tables: Field1, Field2.

The output results are Field1, Field2, Select values from Table1.

But, I cannot check mark of the "Select" field value in the query, it doesn't work.

How can I make it works?
Thanks.

 

[whitesmoke]

if you don't really need the checkbox, make it a textbox control (lookup field) with values 'YES' / "NO" or y / n.
it should work that way.