Form data to query

W

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
 
J

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
 
Top