Form with Multiple Check boxes

[Paul Washburn]

I am trying to write a form with multiple check boxes that will apply filters
to a query result. When none of the boxes are checked all records with be
displayed. If two boxes are checked only records that contain both boxes
would be displayed.

Could someone tell me what the easiest way to do this would be? I was
thinking a switch statement in the where of the sql select.

Thank you for any help.

 

[Steve]

Look at QueryDef in the Help file.

Steve
(e-mail address removed)

 

[S.Clark]

Use VBA code to create a dynamic where clause.

If chkA then strW = "{ConditionA}"
If chkB then
if len(strW) > 0 then strW & " AND "
strW = strW & "{ConditionB}"
End If
If chkC then
if len(strW) > 0 then strW & " AND "
strW = strW & "{ConditionC}"
End If

Replace the conditions with some viable criteria.

 

[Paul Washburn]

Thanks,

where would i put that? Ive tried:

SELECT bncforms_table.formnumber, bncforms_table.form_name,
bncforms_table.edi, bncforms_table.events, bncforms_table.notes,
bncforms_table.[Weather Ntc], bncforms_table.Recipients,
bncforms_table.Chapter, bncforms_table.[No Enter],
bncforms_table.Last_Modified
FROM bncforms_table
WHERE If (Forms![FormRpt]![chkEdi] = True) then ([bncforms_table]![edi] =
true)

But its giving me a syntax error.

Is there a way to declare: Where {variable}

And then build the string on the form and pass it through on the button click?