Refresh Report (Report On top of Form) (1 Viewer)

[cheer]

Let say I got report which contain bar chart on top of form (GUI), how to refresh the report live when data is changed ?

 

[Pat Hartman]

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.

 

[isladogs]

Reports do have a timer event