Query Based on Form Checkbox

[tylerpickering]

Hello,

I have a form setup that will allow a user to check a check box if they want to pull data with certain equipment types (logistics/trucking). I am unsure how to do this in the query...basically (picture attached) I want them to select the equipment type (ex. Dry Van and Temp Controlled) out of seven options and then only those records get pulled in. How do I do this in the "criteria" field?

Thanks so much for the help!

[ranman256]

1 way, is at on RUN QRY button, a macro runs to add each item to a table, tEqFind.
In the macro is a query to add each item to this table.

docmd.openquery "qdEmptyTbl"
(insert into tEqFind [EQ].. where forms!frmFind!chkBulk = true)
(insert into tEqFind [EQ].. where forms!frmFind!chkVan = true)
etc. (if true they get added)

join this tEqFind table to your data table on EQ field, and ONLY those items will retreive.

[tylerpickering]

Thanks for the reply!

Is using VBA the only/best way to go about doing it?

[ranman256]

no, i gave you the NON vb method....(easiest)
the other way with vb would be

2.
build the SQL for the query on button click

dim sSql, sWhere

if chkBulk.value then sWhere = sWhere & "[eq]='BULK', "
if chkVan.value then sWhere = sWhere & "[eq]='VAN',"
... all variations

'remove last comma here

if len(sWhere) > 0 then sWhere = " WHERE " & sWhere

sSql = "select * from tEquip " & sWhere
docmd.opensql sSql

'longer more painful way to get it done.

[tylerpickering]

Thanks again!