Query with form as criteria source

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

I have a query that is the basis of a report. One field in the query is a
checkbox field for applicability. In the criteria for the applicability
field I've established a form that uses an option group. Based on the
user's selection in the form, I would like the report to show applicable and
not applicable and all records based on the user's selection in the form
that is the criteria source. I can get the query to display applicable and
not applicable records, using a 0 or 1, but not all the records.
Thanks for any help!
Jake
 
Back
Top