Searching for entries with certain checkboxes selected

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter query with checkboxes 0
Show select table entries based on yes/no checkbox answers 1
select only one checkbox 2
Count Checkboxes 1
Checkboxes Option Group Questions 1
Checkbox Next to Mail Message - How Do I Make It Visible? How Do I Make a Check Appear? 1
Creating Checkbox Fields For Every Record 0
Access Determine what query to run based on a checkbox 0

Back
Top