Each time you open the report, the query that selects the data will run. If you want to leave a report open all the time, you will need to use a timer event (I'm not sure that Reports even support timer events). The timer event would execute a
Me.Requery
every time the timer fired. If Reports don't support timer events, you would need to use a form with a timer event and the event would close and then reopen the report.