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
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