I have two different Subforms (Graphs) that are based on the same table. Basically I am using them as Dashboards that update every 25 seconds. As long as the focus stay on the 1 rst Dashboard there are no problems but once I click on the Tab that has the second subform I get RunTime Error 2118 'You must save the current field before you run the requery action'. I attached a SnapShot view of the error. Below is the code I am using in the Timer() Event.
Code:
Private Sub Form_Timer()
[FrmDashBoard].Requery
[FrmDashBoard2].Requery
End Sub
