Updating Form==Query==Report
Andre wrote:
I don’t think you can refresh a report that is already open (I might be
wrong, but have never thought of a report as a live object)
With a form you just use the requery command, but an open report is a
snapshot of the data at the time the report was run.
You may want to attempt Reports![MyReportName].requery
FYI, I haven't tried Requery, but I have a few reports that
I "refresh" or whatever on the fly by changing either the
report's Filter or OrderBy property. Either of those
appears to cause the report to start over with its Open
event where you can use code to change all kinds of things
(e.g. the report's RecordSource, controls' properties
including ControlSource, Sorting and Grouping entries, etc.
--
Marsh
MVP [MS Access]
|