checkbox criteria on a from for report

  • Thread starter Thread starter Andrik
  • Start date Start date
A

Andrik

I have a form with checkboxes linked to tables and queries. for example
when i check off SchoolName and School Address on a from and click preview
report button, a report shows up with only these 2 values.
The problem is when i open a form, all checkboxes are grey, and when i
check off a few boxes and click on report preview it gives me an error.
Please help
 
Try making the source of your report similar to:

SELECT SchoolName, Address
FROM tbl_Schools
WHERE (((tbl_Schools.SchoolID)=[form]![FormName]![formField]));

You will need to re-word to the correct names.
Hope that helps,
Renee
 
Back
Top