Multi-column subreport repeats forever

[jtertin]

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!

 

[Guest]

I am so close to getting this fixed. The only problem I have now is the
subform repeating once it finishes creating columns for all of the data in
its query - it RESTARTS at the beginning, causing my report to be of infinite
length. Any suggestions?