News, links, downloads, tips and tricks on Microsoft Access and related
Thursday, August 11, 2005
Recently, while working on Access application as s front-end to SQL Server I came into a problem that you can not bind subreport (and subform) to pass-through query, if subreport linked to main report with Link Master/Child properties. Error message I get is: "You can't use a pass-through query or a non-fixed column crosstab query as a record source for a subform or subreport". Microsoft KB article says that you can bind subreport directly to linked table and then it will work. Yes, it will work, but imagine what happened for a large table? Or if you need to join 2 tables for this subreport? I think better approach is to use a local temporary tables - so just copy your filtered pass-through query to some local table and then use it as a report source.