Report with subreport running slow

[robina]

I have read many posts on this subject but I can't seem to get anything to work. I have a main report based on a query and then a subreport based on a different query. the parent/child fields are txtReqUNID and ReqUNID. Sorted and criteria fields are indexed. I've removed the "order by" sql. I don't have any Dlookups or calculated fields. Both queries are based on the same table. I've run the Access performance analyzer. No matter how long the report has been loaded, each time you page down it is "running query" this takes a long time. I would appreciate any suggestions. The subreport definitely is the culprit but I don't know what to do about it.

 

[robina]

As a follow up, I found a work around for this problem. I did a make table query and used that table as the records source for the sub report. Much faster.