I have a continuous form and I have the timer set at every 1sec to refresh the screen...
But the problem is that my screen keeps on flickering.
This is the code I put in my form timer event..
*****************
Private Sub Form_Timer()
DoCmd.Echo = False
Forms!PCV_Dispatch_form.Requery 'Requery the form
DoCmd.Echo = True
End Sub
and I also tried this one
**************
Private Sub Form_Timer()
Application.Echo = False 'turn off screen updating
Forms!PCV_Dispatch_form.Requery 'Requery the form
Application.Echo = True 'turn screen updating back on
End Sub
Can anyone please help...
But the problem is that my screen keeps on flickering.
This is the code I put in my form timer event..
*****************
Private Sub Form_Timer()
DoCmd.Echo = False
Forms!PCV_Dispatch_form.Requery 'Requery the form
DoCmd.Echo = True
End Sub
and I also tried this one
**************
Private Sub Form_Timer()
Application.Echo = False 'turn off screen updating
Forms!PCV_Dispatch_form.Requery 'Requery the form
Application.Echo = True 'turn screen updating back on
End Sub
Can anyone please help...