Prev: Bound Chart in Report Issues - Access 2007
Next: email recipient address shows twice
From: Dan on 22 May 2010 22:41
I have a date form. It has 2 text boxes that pass starting and ending dates
to a query to pull appts from that time period. If the report is left open
and the dates change in the date from, I have to manually refresh the report.
Is there a way that when I click off of the 2nd text box (ending date on
date form) that the data updates when I click back on the open report that it
all updates (Rpt.GetFocus = event) perhaps? The reason I ask is that the
reports are pulled up evey hour and the operators would like the already open
report to update once the form gets focus. This is probably not the right
method, so i am asking for any offered solutions. Thanks for all help!

Dan
From: Andre on 23 May 2010 01:57
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




"Dan" <Dan(a)discussions.microsoft.com> wrote in message
news:58D33BF4-32F2-4F03-8D98-3C8080D742AF(a)microsoft.com...
> I have a date form. It has 2 text boxes that pass starting and ending
> dates
> to a query to pull appts from that time period. If the report is left
> open
> and the dates change in the date from, I have to manually refresh the
> report.
> Is there a way that when I click off of the 2nd text box (ending date on
> date form) that the data updates when I click back on the open report that
> it
> all updates (Rpt.GetFocus = event) perhaps? The reason I ask is that the
> reports are pulled up evey hour and the operators would like the already
> open
> report to update once the form gets focus. This is probably not the right
> method, so i am asking for any offered solutions. Thanks for all help!
>
> Dan

From: Marshall Barton on 23 May 2010 18:08
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]
 | 
Pages: 1
Prev: Bound Chart in Report Issues - Access 2007
Next: email recipient address shows twice