Access2000 stalls when using a subreport

M

Mervyn Thomas

I have a master query containing 350 records and two subreports the one
containing 2200 records and the second containing 4500 records. Both of the
reports use the same field to link to the master and both reports are sorted
by this link field. Both subreports work fine on their own.

The Master report containing the first subreport functions well but when I
try to run a copy of the master report which contains the second subreport
Access freezes and goes into "not responding" mode and I have to do an "end
Task" in XP. After doing this the whole computer is very slow and
does'nt recover unless I reboot! Memory used up??

Can anyone suggest how to put this right? I obviously want to get to
running at least two subreports within the same master.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top