Search by Form with Checkboxes

L

LDMueller

I have Access 2003. One of my Tables has multiple fields with the Data Type
Yes/No and a Display Control of Checkbox.

I have a query by form with multiple text boxes and a related query. One of
my query examples is listed below.

Like "*" & [Forms]![F_CatSearch]![txtGumChewing].

I need to be able to make multiple selections for my query's output. My
problem is in the form I have to put "-1" in the field for my query to work.
I want to be able to have a checkbox in my form so the user can check the
items they want selected in the query.

Can anyone help with this?

Thanks in advance!
 
H

hmadyson

I think that you only need to make the default of each checkbox be false and
then they will be "ready to use".

Please let me know if you need more assistance.
 
L

LDMueller

Hello,

Thank you for your response, however assuming you meant changing the default
of the checkbox to be false for the table, this doesn't really help me having
to enter a "-1" on my form to get the query to work.

Thanks!

hmadyson said:
I think that you only need to make the default of each checkbox be false and
then they will be "ready to use".

Please let me know if you need more assistance.

LDMueller said:
I have Access 2003. One of my Tables has multiple fields with the Data Type
Yes/No and a Display Control of Checkbox.

I have a query by form with multiple text boxes and a related query. One of
my query examples is listed below.

Like "*" & [Forms]![F_CatSearch]![txtGumChewing].

I need to be able to make multiple selections for my query's output. My
problem is in the form I have to put "-1" in the field for my query to work.
I want to be able to have a checkbox in my form so the user can check the
items they want selected in the query.

Can anyone help with this?

Thanks in advance!
 

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

Top