How to filter data using checkboxes?

[qwerty]

Could someone just provide an example of how to code a checkbox. I have checkboxes on Form A with a category A, B, and C. I want to be able to check one or multiple categories to filter the list box to that specific results in Form B. If left unchecked then all results show. How would you write such coding?

[ranman256]

in a continuous form, when user clicks Filter button, check all the boxes to build the where clause:

'----------------
sub btnFilter_click()
'----------------
dim sWhere as string 
sWhere = "1=1"
if chkSmokers.value then sWhere = sWhere & " and [smokers]= true"
if chkAdults.value then sWhere = sWhere & " and [Adult]= true"
if not IsNUll(cboZip) then sWhere = sWhere & " and [ZipCode]='" & cboZip & "'"

If sWhere = "1=1" Then
  Me.FilterOn = False
Else
  Me.Filter = sWhere
  Me.FilterOn = True
End If
end sub

[ssanfu]

Cannot give a good answer because the question is too vague.

What I can determine is there are two forms involved, "FormA" and "FormB".
"FormA" has 3 check boxes to select up to 3 categories. You want to be able to check 1 or more check boxes to filter on one or more categories (fields?).
This filter is to be applied to a list box on "FormB".


There are no object names, no examples of data, no categories. When is "FormB" opened? Is "FormA" still open when "FormB" opens??

Very hard to write code when nothing is defined...

[qwerty]

Cannot give a good answer because the question is too vague.

What I can determine is there are two forms involved, "FormA" and "FormB".
"FormA" has 3 check boxes to select up to 3 categories. You want to be able to check 1 or more check boxes to filter on one or more categories (fields?).
This filter is to be applied to a list box on "FormB".


There are no object names, no examples of data, no categories. When is "FormB" opened? Is "FormA" still open when "FormB" opens??

Very hard to write code when nothing is defined...

Almost correct, in the query there 2 tables that relate by the scientific names. One table has a criterias relate to the scientific name the other table is by location. The checkboxes control source is with the criteria. I want to be able to filter the related the sciname in the location table based on fields in the criteria that equal to -1. The scientific appear in a listbox on Form B, if left unchecked I want all species showing.

[ssanfu]

Again, no field names, no table names, no images of the relationship window, no images of the forms or form names....

Maybe post an example dB with the tables and the forms involves.