changing subreport details

[angellrp]

I'm trying to change the source of a subreport. but the code I'm using doesn't work. Can anybody help me?


code I'm using is:

DoCmd.SetValue Reports![Main_Report]![SubReport1].SourceObject.stSRreport

I've also tried

DoCmd.SetValue Reports![Main_Report]![SubReport1].SourceObject = stSRreport

Regards

Angela

 

[KenHigg]

I think you need something like:

DoCmd.SetValue Reports![Main_Report]![SubReport1].report.SourceObject.stSRreport

???
ken