Master report to show only current record

[andrewhoddie]

Hi all

I have created a master report called Details which has Report1 Report2 Report3 upto Report8 on it. However I am unable to get the master report to only show the current record from the form via a command button. Each of sub reports is set to show current record as is the master but this isn't working.

What I need to be able to do is print/view the master report for the current record only.

please can someone advise how to resolve this

many thanks
Andrew

 

[Micron]

When you open the report with the form command button, your code should apply a filter to the report. The value can come from a form control or field, but the main report recordsource has to have this field in common with whatever the form is based on (table or query field). Pretty sure that the field value for the currently selected record is passed to the form automatically and you can get it by using Me.NameofYourControl. Use the WhereCondition parameter of the DoCmd object for opening a report:
OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)
You might want to code for the possibility that a user clicks the button when no record is selected.
BTW - 8 subreports on a main report seems too extreme. I thought the max permissible was 7 too.