I tried to build a subreport with a pass through query as the record source and an error message is shown "Pass through query can't be the record source for the subreport". Is it a limitation in Access? I know the subreport can work with the linked table. Thanks a lot.