Checkbox sql statement

I need a sql statement, if a user submits the form without checking the
checkbox all records will show but if he checks one only that record will show.
im lost please help. herer is the sql statement SELECT * FROM Gems_Query
WHERE CatCode = 'MMColParam' and (Shape LIKE '%MMColParam3%' or Shape =
'MMColParam1' or Shape = 'MMColParam2' or Shape = 'MMColParam4') catcode is
the from a listbox and shape is the checkboxes how can i do this where if they
dont check it it shows all the dropdown selection if they do show the dropdown
selection where the shape matches the checkbox please help thank you in
advance.