I have 10 commenst on my form and the user can click as many. When the report is produced I would like only the checked expressions to appear. Is it possible to do that? At the moment evrything on the form is appearing on the report. Please help me.
in the query have the fields you want and under the checkbox field put a statement such as.
Forms!Yourform!checkbox!= True
so you have the form, the user checks the boxes, put a button on the form to lauch the report , the query uses the form data to open the report with the selected info..
Please somebody help me with this problem as I must finish this by tonight. I cannot create a report which doesn't print the check boxes that are not ticked. Many thanks.
Is this still the same thing where I gave you the select a comment example? If so, you can add another field into the table underlying the subform that has a Yes/No data type. Fix this into the query.
Then build a query off this query ensuring that only the ticked are selected.
you have your form with the records and the checkbox field..
lets call it checkbox1
so you create a query with the fields you want the report to show. then on the checkbox1 field you put in the criteria
forms!yourform!checkbox1 = true
you can do this through the expression builder within the query design screen so you dont have to type it out just click on the form and the object.
ok.. so now on the form have a button which opens the report.
when the report opens the query it is based on will look at the form and only show you the records you want.. you can chekc this by just running the query, it should show you the records you require...