OK I have a a Form called frmShipsAudit.
Within this from I have a SubReport with to reports embedded RptShipEquip and RptShipPanels. I want to programmatically change the recordsource (same data just a different clause)
So I tried the code below but get this error MS Access error 2465 can't find the field report referred to in your expression .
Me!RptShipEquip.Report.RecordSource = strSQl
Me!RptShipPanels.Report.RecordSource = strSQl
This works fine for an SubForm I have but not for reports.