dynamically link subreport

[jordanking]

Hello,

I have a master report that i want to link a subReport to. However, both the reports RecordSource is set progamically in the Report_Open event. The Recordsource is set to a dynamic query returned from a sql server back end (.adp 2007 front end). Both the reports have a grouping expression on [chrDriverName] and I put this same field name in both the Link Child and Master fields of the subreports properties. This does not work.

Is it possible to link reports that are not based on tables or queries already saved in the DB?

Thanks in advance

.....
I'd rather be surfing

 

[SkipVought]

Hi,

You might want to post in Forum703.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jordanking]

i will

.....
I'd rather be surfing