Report coming up blank with no data.

  • Thread starter Thread starter Bryan F.
  • Start date Start date
B

Bryan F.

I built several databases for one customer of mine. All of
a sudden one of them started loading reports with no data
in them, when the data is certainly in the database and
has been forced a save. I have upgraded all the computers
with the latest service packs to office and Jet. Here are
some of the steps i've tried:

1: call the report with an unfiltered recordset using the
Docmd.PrintReport filter option to apply the filter.
2: call the report with a filtered recordset, queried
against the actual control on the form containing the
value to filter on.
3: Open the report in design view, applyed a filtered
recordset, saved, closed and reopened in preview mode.
4: Imported all database elements into a new database.

All of my code compiles with no problem and the database
has been compacted and repaired many times.
Any Ideas????
Thanks,
Bryan F.
..
 
What happens if you run the report directly without any WHERE clause? Same
thing, or do you see the data?

Larry Linson
Microsoft Access MVP
 
I ran the report with no filters straight out of the
database window. Everything seemed to show up fine. Also,
I should probably tell you that it is only the recordset
behind the main report that does this... all subreports
seem to populate just fine.
 
Back
Top