Controlling Sub Report Data

[buskgrim]

Hi,

How can I set the recordsource of a sub report based on a field value in the main report.

The field in the main report is simply the rank order of the records.

The value of the field in the main report determines whether the query returns the top 10 records, the bottom 10 records or 5 records either side of the field value.

Many thanks

Kevin.

 

[Wocca]

You can use multiple Child/Parent fields which would do what you want.

Regards
Warwick