Any way to refresh a report?

  • Thread starter Thread starter Darrell Childress
  • Start date Start date
D

Darrell Childress

Just wondering, is there a way to refresh the info displayed on a report
other than closing it and re-opening it? We bring up a report in a daily
meeting, and use that report to discuss jobs, then make changes to the
data (we don't close the report). I know you can refresh (requery) a
form, but I can't find anything like that for a report.
 
As far as I know, you have to close and reopen the report. The report is a
static representation of the data at the point in time it is executed.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Darrell said:
Just wondering, is there a way to refresh the info displayed on a report
other than closing it and re-opening it? We bring up a report in a daily
meeting, and use that report to discuss jobs, then make changes to the
data (we don't close the report). I know you can refresh (requery) a
form, but I can't find anything like that for a report.
Click to expand...


Never heard of such a thing. However, a report will restart
itself when you change it's Filter or OrderBy property. If
you have a form open where you are changing the values, then
try adding a command button that executes code like:

Reports![your report].OrderBy = "[some field name]"
Reports![your report].OrderByOn =True

If you are using Sorting and Grouping in the report, then it
probably won't make any difference which field you use.
 
Why not create a form that looks similar to your report, and use the form in
the meeting.

Then, when you won't need to requery, as the data is being changed in the
form.

And if that is not enough, you could keep track of what record you are on,
and immediately after the requery, go back to that same record.
 
Back
Top