oh, then the form would build a 'where' clause depending on what you checked.
since I don't know the tables, im guessing, either:
make an invisible box to hold the 'where' clause when checked.
Code:
chkBox1_afterUpdate
BuildWhereFromBoxes
end sub
sub BuildWhereFromBoxes()
if chkBox1.value then txtWhere = "[field]=true
if chkBox2.value then
if txtWhere <> "" then txtWhere = txtWhere & " and "
txtWhere = txtWhere & "[field]=true
endif
end sub
Then add the where to the sql
OR
the checkboxes are connected to fields in a table. This table is joined to the data to pull only that data.