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" wrote in message
...
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