In a report, I have a subreport based on a very complex query. I would like to run the data source as a pass-thru query.
When I do, I get this error:
"You cannot use a pass-through query or a non-fixed column crosstab query as a record source for a subform or subreport."
It also says that I need to specify the column headers, but that only applies to crosstabs.
In 2011, a guy wrote "I found a solution to this part. I made a function that returns a recordset, and then I bind this recordset to the form's recordset." But when I open the subreport and execute this:
Expand|Select|Wrap|Line Numbers
- Me.Recordset = MyFunction(SomeSQL)
Any ideas?