Generating a report based on checkboxes

[mhughes1988]

I would like to have a form with a list of checkboxes corresponding to fields in a table.
Then have a report generate showing only those selected fields.
For my first try, I had a report with all the fields on it set to invisible and tried code like "if check1 = true then label1.visible = true" (obviously simplified)
However i could not make this work, and if the user only selected a few fields the report wouldnt look good because there could be alot of white space for where the other fields are hidden.

Any suggestions on how I could make this work?

 

[dcobau]

Seems to me that you have not based your report on a query.

1) Create a query with criteria check1 = true. This will display only the records that match the criteria (BTW, you can also use -1 or yes in place of true).
2) Base the report on the query and not on the table.

Dave