refresh report datasource

  • Thread starter Thread starter Thomas Toews
  • Start date Start date
T

Thomas Toews

I'm using Access 2003 with a report that has it's own query as a datasource
(not a separate, saved query). I would like to refresh that report, if it is
open, when data is changed in the underlying table. I've tried the following
refresh/requery commands and none of them work. All return an unkown error
at the refresh/requery statement.

Form_AfterUpdate
Set rpt = Reports![Accept By Date]
If rpt.Visible = True Then
rpt.DataSource.Refresh
rpt.Requery
rpt.Refresh
End If

Tom
 
You can't refresh the data on the report, the only thing you can do is, close
the report and reopen it.



\\// Live Long and Prosper \\//
BS"D
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh, Requery, Repaint?? Which One? 1
Pivot tables not refreshing after data source update 1
multiple instance of report in access 0
subform behavior 1
Refresh Data in a subform 2
Refresh data in sub forms when one sub form is edited 4
Subform not refreshing 2
Command to Close and Reopen Sub Form 1

Back
Top