Form data to query

[WWV]

This may be easy but it's late and I can't figure it out. I have a tbl with
a lot of Yes/No fields. I would like to show the user a form and have them
select the Y/N fields to includ in a query rhat will generate a report
(labels). How can I pass the Y/N fields checked to a query?
Thanks
WWV

 

[Jamie Richards]

Provided your form will be loaded when you open the query or report, insert,
into the query WHERE clause, a reference to the form control containing the
value you want as a criterion:

fldYourField = Forms("frmYourForm").ctlYourControl


Jamie