Lost sub report

  • Thread starter Thread starter Bob Griendling
  • Start date Start date
B

Bob Griendling

While working with reports today in which each one copied the previous one
with data sources changed, I suddenly lost all the subreport info in the
report. In the design view, there is a while box that names the report but
the info clearly isn't there, although the sub report itself is alive and
well with the correct info in it.

What have I done? How do I get it back?
 
So the subreport works when you use the report, but in report design view,
you just have a white rectangle where the subreport should be?

Access opens design view like that if the subreport is already open
somewhere. So, if you have Report1 open with this subreport open there, and
then you open Report2 which uses the same subreport, Access cannot also show
you the same subreport in design view on Report2. Similarly, if you open the
subreport itself first, and then open Report1, it cannot be in design view
there as well as by itself.

If that is not what's going on, try compact/repairing the database:
Tools | Database Utilities | Compact/Repair

If the problem persists after that, post a reply for further instructions.
Access 2000 and later has 2 lists of reports, and sometimes these can get
out of sync so the database is corrupt. Under some circumstances, copying
and pasting in the database window can trigger this corruption.
 
Back
Top