Generating a Report from a Subform

[rcrex]

I'm trying to generate a report using information from both a form and its subform.

The subform contains multiple records and I'm using a query to generate the report.

What I cannot seem to get the report to do is to iterate or loop through the records in the subform and make a control on the report visible or not depending on the value (true/false) of a given field in each record.

I feel like I've tried everything....any suggestions?

 

[Remou]

Have you considered setting the recordsource of a subreport to the recordsource of the subform and using conditional formatting to set the visibility of the relevant control?

 

[rcrex]

Thanks for the quick response -- I finally got it working by using an IIF statement in the control source for the control. Not as elegant a solution as yours -- but it works! Thanks again!