S
SlydeRule
How can I set a Filter or change a Recordsource in a sub-report. It doesn't
let me do it in the sub-reports Open sub, and I can't get it to work from the
parent report either. I've tried different variations of these statements:
Me.rpt_AI_Detail.Report.Filter = "AssignedToID = 3377"
Me.rpt_AI_Detail.Report.Recordsource = "Select * FROM tblAI WHERE " & xFilter
The errors I get in the parent report basically say "Invalid reference to
the property". In the subreport it either says I can't change the
recordsource because printing has begun, or the filter is not updateable.
The subreport is linked to the parent by an ID field, but there are 6
possible OpenArgs to the parent that further define what the subreport shows.
Any suggestions would be greatly appreciated. Thanks...
Dave
let me do it in the sub-reports Open sub, and I can't get it to work from the
parent report either. I've tried different variations of these statements:
Me.rpt_AI_Detail.Report.Filter = "AssignedToID = 3377"
Me.rpt_AI_Detail.Report.Recordsource = "Select * FROM tblAI WHERE " & xFilter
The errors I get in the parent report basically say "Invalid reference to
the property". In the subreport it either says I can't change the
recordsource because printing has begun, or the filter is not updateable.
The subreport is linked to the parent by an ID field, but there are 6
possible OpenArgs to the parent that further define what the subreport shows.
Any suggestions would be greatly appreciated. Thanks...
Dave