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

cheer

Registered User.
Local time
Today, 07:04
Joined
Oct 30, 2009
Messages
222
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

Super Moderator
Staff member
Local time
Yesterday, 19:04
Joined
Feb 19, 2002
Messages
43,275
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

MVP / VIP
Local time
Today, 00:04
Joined
Jan 14, 2017
Messages
18,221
Reports do have a timer event
 

Users who are viewing this thread

Top Bottom