having a form requery on timer 1

[WallT]

I have a form that i need to requery every couple of minutes, however, i have never used the OnTimer Event, and have failed each time I have tried. Can somebody please point me in the right direction?

 

[TheAceMan1]

How are ya WallT . . . . .

In the [blue]OnLoad[/blue] event of the form:

[blue]   Me.TimerInterval = [purple][b]TimerValue in milliseconds[/b][/purple]

Example:
    Me.TimerInterval = [purple][b]1000[/b][/purple] 'One Second Timer[/blue]

Then in the OnTimer event of the form:

[blue]   Me.Requery[/blue]

[purple]Cheers![/purple]

See Ya! . . . . . .

 

[WallT]

Perfect. Thank you.