pass-through query for subreport

[yuchieh]

I tried to use a pass-through query for a subreport and got an error. I found out that pass-through query cannot be used for subreport. Is there a way to work around it? Also, there is filter for the main report and the subreport will display the results based on the filter from the main report.

Thanks

 

[PaulBricker]

Here is something you can try.
Create a Make-Table query using your pass through query as the source. Then create your subreport from the table and set the Master/Child link. You may have to type in the links manually. Access whined a little when I did it, but it ran properly once I did that.
The issue will be refreshing the data. At that point, you can automate the process from a form button with code like this

Private Sub Command2_Click()

DoCmd.SetWarnings False
DoCmd.RunSQL "Select PassThruQueryName.* Into tblPassThru From PassThruQueryName"
Docmd.SetWarnings True
DoCmd.OpenReport "ReportName",acViewPreview

End Sub

That may get you pretty close to what you need.

Paul