Multi-parameter query

[johnnyvino]

I have a query to a table with several Yes/No fields.



I would like to create a form where I have the option to enter Yes for any (or multiple) of those fields, and then run the query to get data sheet result.

Is there an easy way to do this that I'm completely missing?

Thanks!

[ranman256]

no , not easy. If you want it easy the USER , then you must write code to analyse the check boxes marked.

You cant use form boxes in a query if there's nothing in them..so..
Test all controls for a possible filter then build the where clause.
the form is a continous form of records of all until the filter applies.
then the Find button would run this

sub btnFind_click()
if not isnull(cboState) then   sWhere = sWhere & " and [state]='" & cboState & "'"
if not IsNull(txtName) then    sWhere = sWhere & " and [Name]='" & txtName & "'"
if not IsNull(chkContact) then sWhere = sWhere & " and [Contact]=" & chkContact.value

    'remove 1st And
sWhere= mid(sWhere,4)

  'just use the filter

me.filter = sWhere
me.filterOn = true
end sub