Difficulty with a subform and its report

[mdspoc]

In Access 2000 I have a Form that contains a Subform; the Subform contains 20 separate items each with a yes/no checkbox.

I want to generate a Report in which is displayed the data from the Form and the Subform - but I want to display ONLY a list of the items in the Subform which have been selected (ie. ticked yes), not the whole 20 items.

I know how to generate a Subreport within a Report, but at present my attempt shows the complete list of the whole 20 items (with some ticked, other not).

Is this possible? I'd be grateful for any help. Thank you.

 

[Carol]

In the query for your report, in the criteria line for the checkboxes, state Yes. This will only pull records that are true or have been ticked.

 

[mdspoc]

Thanks for the tip - but I'm still stuck. Perhaps I don't know enough about Queries yet. I generate the Report for the Form using the Report Wizard, then use the Subform/Subreport button to insert the Subreport of the Subform, with two shared identical fields to link them. I've tried using a Query as well with Yes in the criteria line of the appropriate fields, but still get the whole subform displayed.

 

[pcs]

from the 'quick and dirty department'
on your subreport set these properties:
filter: [YourCheckBoxName]=True
filter on: Yes

hth,
al

 

[mdspoc]

Thanks. Re setting properties on the subreport; I've tried this now and it does not appear to work; all fields (ticked or not) are still displayed.

 

[Carol]

Sounds to me as though you are using the forms recordset to display your report. Set up a new query for your report and do as I said previous. If you are still having problems, you can e-mail a small database with your report and I will fix it for you.