Report coming up blank with no data.

[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.
..

 

[Larry Linson]

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

 

[Bryan F.]

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.