View Single Post
  #1  
Old July 18th, 2007, 01:30 PM posted to microsoft.public.access.reports
jtertin
external usenet poster
 
Posts: 31
Default Multi-column subreport repeats forever

I have a multi-column subreport embedded into an access report which
works fine, but loops without end.

The form should put all of the data from a query in columns and stop,
which it does if you open the report that IS the subform. The last
column of data represents the last row in the query. However, when I
use that report as a SUBreport, it starts over again after the last
column is printed and loops forever. Any reason that this might be?

I had the problem at first of having every page display the SAME
[first] 10 columns of data (because my subreport is set to display 10
columns). Setting the subreport's "Can Grow" property to Yes solved
this issue, but I have heard of a bug related to that property being
set in subforms also. Could this be the problem, or do I need to use
master/child linked fields somehow to keep the columns from repeating?

Thanks!