Refresh All on a form

macca

Registered User.
Local time
Today, 13:02
Joined
Aug 24, 2005
Messages
16
Hi

I have a form called "frm_Q_all" and it has 2 text box fields called "ASP" and "CAT".
These fields are from a query called "Q_all"

I want to keep the form open and have these fields to refresh every 30 seconds. When I press the Refresh All button it works but Imy code below does not work
Can anyone help me

Code:
Private Sub Form_Timer()
Me.ASP.Requery
Me.CAT.Requery

Me.Refresh
Me.Repaint
End Sub
 
Did you set the Timer Interval property of the form in milliseconds?
 
Yes, however I have it working now
 

Users who are viewing this thread

Back
Top Bottom