Checkbox in forms and report

Suzy

Registered User.
Local time
Today, 08:42
Joined
Jan 20, 2004
Messages
29
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.
 
try this

you could have the report being run off a query.

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..

hth

John
 
This idea did not work, I must be doing something wrong...can you elaborate please. The report is still showing all fields !!!
 
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.
 
Suzy,

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.
 
ok..

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...

hth

John
 
Sorry, but I couldn't follow that...I am a bit daft I guess. Would you kindly explain it in a bit more detail....Thanks
 
apologies mile, did not see you had replied also...

Suzy, if Mile has suggested then above then go with that..
 
Thanks John I shall try that now.....this time I did follow you.
 

Users who are viewing this thread

Back
Top Bottom