Searching for entries with certain checkboxes selected

D

djknight

Hi there, I am kinda new to Access and so I would like to as a question. See,
Im building this database where I have an entry with "name" and "last name"
and some checkboxes. Some of them are selected and some are not... what i'm
trying to do here is make a form that will allow me to tick some checkboxes,
press a button and show (in a subform or new form) ONLY the entries that have
the checkboxes i just checked already ticked.

I hope I'm making sense... please, any feedback is welcome...

djknight
 
K

KARL DEWEY

Use a query as record source for the subform or new form. Use the checkboxes
as criteria in the query. In the design view add a column like --
X: [Forms]![YourMainForm]![CheckBox]
Use -1 (minus one) as criteria for when the box is checked and 0 (zero)
when it is not checked. You should set the default of the checkbox to one or
the other.


The value
 
Top