I have several reports in an Access 2000 database.
The reports are based on a query that includes a value from a form as one of it's parameters.
E.G. Select * from foo where foo_id=[Forms]![frmMain]![foo_id]
At SOME times, the reports will come up BLANK.
If you close and come back a few minutes later, the report will load.
This is a distributed MDE application, with multiple users.
I thought at first this might be some sort of locking issue.
However, I have not been able to replicate the problem based on a locking theory. (open the "foo_id" record on the form, report still loads Ok, have another copy of the report open, report still loads OK, etc.)
The next thing I'm going to try is removing the query parameter and instead filtering the report
(E.G. DoCmd.OpenReport "rptFoo", acViewPreview,,"([foo_id]=3)")
However, I'm not getting warm fuzzies about modifying the app on the CHANCE that it might fix this problem. I'd rather know the absolute CAUSE and proven SOLUTION before I proceed.