Private Sub Form_Timer()
Remarks
To run a macro or event procedure when this event occurs, set the OnTimer property to the name of the macro or to [Event Procedure].
By running a macro or event procedure when a Timer event occurs, you can control what Microsoft Access does at every timer interval. For example, you might want to requery underlying records or repaint the screen at specified intervals.
The TimerInterval property setting of the form specifies the interval, in milliseconds, between Timer events. The interval can be between 0 and 2,147,483,647 milliseconds. Setting the TimerInterval property to 0 prevents the Timer event from occurring.
Example
The following example demonstrates a digital clock you can display on a form. A label control displays the current time according to your computer's system clock.
To try the example, add the following event procedure to a form that contains a label named Clock. Set the form's TimerInterval property to 1000 milliseconds to update the clock every second.
Private Sub Form_Timer()
Clock.Caption = Time ' Update time display.
End Sub