WHERE Lab = [Forms]![My Sites Groups]![CheckLab] OR Lab = -1

If Checklab is checked you will see all records where Lab is True. If
checklab is not checked you will see all records where Lab is False (0) plus
all records where Lab is True (-1)

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Silvio wrote:
Hello, I would like to see ALL (0 and -1) records if my check box in my form
is not checked (0) and if checked (-1) I would like to see only record with
-1 (with check mark)

This is what I have, but as expected it will return only record with 0 OR -1

SELECT tblSite.Site, tblSite.Lab
FROM tblSite
WHERE (((tblSite.Lab)=[Forms]![My Sites Groups]![CheckLab]));

Thank you,
Silvio