Hi
I need to do a report showing a schedule for a whole week. Each day's schedule is calculated in the same and so I thought of creating a subreport and calling it 7 times from the main report. I have include 7 subreport controls in the main report and called them SR1, SR2,.....SR7.
I am managing to call the subreports by using:
Me.Controls("SR" & i).SourceObject = "Detailed_Subreport"
In the Open event of the main report. Question is how can I make each instance of the subreport behave differently (i.e. generate the schedule for the respective day of the week).
The subreport is getting the starting date of the week from a label in the header of the main report. So all I need is to have an integer from 0 to 6 passed to each of the 7 subreports so that each one generates the schedule of the different day. How can I do it?
Can I, in the subreport, get the name of the control that called it in the main form?
Thanks
I need to do a report showing a schedule for a whole week. Each day's schedule is calculated in the same and so I thought of creating a subreport and calling it 7 times from the main report. I have include 7 subreport controls in the main report and called them SR1, SR2,.....SR7.
I am managing to call the subreports by using:
Me.Controls("SR" & i).SourceObject = "Detailed_Subreport"
In the Open event of the main report. Question is how can I make each instance of the subreport behave differently (i.e. generate the schedule for the respective day of the week).
The subreport is getting the starting date of the week from a label in the header of the main report. So all I need is to have an integer from 0 to 6 passed to each of the 7 subreports so that each one generates the schedule of the different day. How can I do it?
Can I, in the subreport, get the name of the control that called it in the main form?
Thanks