Auto Update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that uses a query as the data source. As the data changes in
the database, the report does not show the updated info when I bring it up.
Is this normal?
 
LDanix said:
I have a report that uses a query as the data source. As the data
changes in the database, the report does not show the updated info
when I bring it up. Is this normal?
Click to expand...

If you are expecting an already opoened report to reflect change then it
will not. It should reflect changes any time it is opened. If you just got
through making the changes are you sure you are saving them before you open
the report?
 
I don't expect the report to update while open. But I do want it to update
when I reopen it. What's weird is that the query is updated with the change
but the report based on the query is not (even when I close and reopen it).
 
LDanix said:
I don't expect the report to update while open. But I do want it to
update when I reopen it. What's weird is that the query is updated
with the change but the report based on the query is not (even when I
close and reopen it).
Click to expand...

Sorry, but that is not really possible. The report's RecordSource query is
re-run every time the report is opened. If the query sees the changes then the
report must see them. To suggest otherwise would mean that the report was
somehow "remembering" the data in a state that no longer exists.

Are you perceiving this lack of updating to only affect new records or does it
also appear to affect updates and deletions as well?
 
Back
Top