Please Help!? Multiple Check Boxes in Query!

[A. Smart]

In my query there are a number of Check Box Fields. I would like to be able
to filter out all the other check boxes when a check box is selected from a
combo box in a form.
Heres how the criteria should go:

If in my form combo box fieldname matches fieldname in query then filter the
check box for true only and filter out all other checkboxes.

Genericly Speaking:
If[Forms![Formname]![ComboBox]= [Fieldname of Check Box] Then [Filter
Checkbox True]
and If[Forms![Formname]![ComboBox] <> [Fieldname of Chck Box] Then [Filter
Out]
Hope its Clear. Please Help,

 

[[MVP] S.Clark]

Personal pet peeve of mine... the Checkbox instead of relational data.

Anyhoo:

Select * from tablename WHERE tablename.fieldname =
Forms![Formname]![ComboBoxName]
or
Select * from tablename WHERE tablename.fieldname <>
Forms![Formname]![ComboBoxName]
or
Select * from tablename WHERE tablename.fieldname NOT
Forms![Formname]![ComboBoxName]

Season to personal taste or preferred flavor.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[A. Smart]

I am entering the data you have given me into the criteria box but I keep
getting parenthesis errors, after adding them I don't get anything! Hair
puller!!
--
Regards

Ashley Smart

Personal pet peeve of mine... the Checkbox instead of relational data.

Anyhoo:

Select * from tablename WHERE tablename.fieldname =
Forms![Formname]![ComboBoxName]
or
Select * from tablename WHERE tablename.fieldname <>
Forms![Formname]![ComboBoxName]
or
Select * from tablename WHERE tablename.fieldname NOT
Forms![Formname]![ComboBoxName]

Season to personal taste or preferred flavor.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

In my query there are a number of Check Box Fields. I would like to be
able
to filter out all the other check boxes when a check box is selected from
a
combo box in a form.
Heres how the criteria should go:

If in my form combo box fieldname matches fieldname in query then filter
the
check box for true only and filter out all other checkboxes.

Genericly Speaking:
If[Forms![Formname]![ComboBox]= [Fieldname of Check Box] Then [Filter
Checkbox True]
and If[Forms![Formname]![ComboBox] <> [Fieldname of Chck Box] Then [Filter
Out]
Hope its Clear. Please Help,

 

[John Vinson]

I am entering the data you have given me into the criteria box but I keep
getting parenthesis errors, after adding them I don't get anything! Hair
puller!!

Ashley (and others)...

Putting pleas like "Please Help!?" in your Subject line is really not
necessary and can be counterproductive. I'll assume that anyone
posting a question here wants help - that's what the newsgroup is FOR,
after all!

It won't get you a faster answer or a better answer, at least not from
me. Consider just posting a brief descriptive subject for the problem
(such as "Multiple check boxes in query"); we'll answer it, as we do
the other questions posted here.

John W. Vinson[MVP]