Refresh a subform or form automatically

[Poloxstar]

hi,
I need assistance with forms. I am looking to automatically refresh a form every 2 minutes. Does any know the VBa code to do so. thanks

 

[ZmrAbdulla]

Use the timer event to refresh.
Timer interval=2000

Zameer Abdulla
Visit Me (New Look & style)

 

[Poloxstar]

Do i put it on the form load?

Can you be more specific on what to do?

 

[ZmrAbdulla]

Form does have a TimerEvent as Load, Open etc. Scroll through the events, it is near to the bottom.
Your code will be like below.

Private Sub Form_Timer()
	Me.Refresh
End Sub

Zameer Abdulla
Visit Me (New Look & style)

 

[Poloxstar]

It is not working? where does the Timer interval=2000 come into play?

 

[ZmrAbdulla]

Just after the OnTimer Event in the property box you can see Timer Interval. There you have to add 2000. It means 2 minutes/2000 milli seconds.

BTW, What are you going to do after refreshing the form? Some time you have to use Me.Requery to get the data refreshed.

Zameer Abdulla
Visit Me (New Look & style)