G
Guest
Hello, how can I modify the code below to allow all the records to be
displayed if the check mark is off? In other words, I have a table with
records with checkmarks (Yes/No field) and records without. I am using a
query looking up a form which has a checkbox unbounded field. What I want is,
if checkbox in the form is selected then only records with the check mark
from the table should be retrieved. However, if the checkmark is off, then
all the records should be retrieved including these with a checkmark from the
table.) Thank you for your help.
SELECT Table1.test, Table1.yesno
FROM Table1
WHERE (((Table1.yesno)=[Forms]![Form1]![Check0]));
displayed if the check mark is off? In other words, I have a table with
records with checkmarks (Yes/No field) and records without. I am using a
query looking up a form which has a checkbox unbounded field. What I want is,
if checkbox in the form is selected then only records with the check mark
from the table should be retrieved. However, if the checkmark is off, then
all the records should be retrieved including these with a checkmark from the
table.) Thank you for your help.
SELECT Table1.test, Table1.yesno
FROM Table1
WHERE (((Table1.yesno)=[Forms]![Form1]![Check0]));