Hiding Record in Report based on checkbox value - Access 2003

[Oscar Mike]

Hi everyone,

I'm new enough at Access 2003 but I have been tasked at work with making a licensing database. I have a main form, and on that form is a subform called "Remarks". I have a report to print off a licence for that particular person. What I want to be able to do is check a checkbox in my "remarks" subform that will hide that record on the report. I've tried hiding the individual fields off the record on the report using the visible tag but it's not ideal as it still leaves an empty white space where everything is hidden.

Thanks in advance for your help.

Oscar

 

[cheshire_smile]

Have you tried changing the record source of the report and adding the condition "where ID <>" CheckboxName???

Not sure if this applies here. you did'nt post much info to work with. you may want to compress and post a copy of your file.

 

[Oscar Mike]

I feel like an idiot now, but sure I'm only starting out. I used a query instead of basing the report on a table. And in that query I put criteria for the checkbox as -1.

Thanks for your help anyway.