I need to be able to refresh a control without the user having to activate it. I managed to do this using a timer interval, but having this constantly running slowed the other applications down too much. Does anyone know a better solution?
Hope this helps :<br>
After the user adds a record, you could 'refresh'..or you could refresh on almost any event...<br>
<br>
Private Sub cmdRefresh_Click()<br>
'This is only needed for multi user apps<br>
On Error GoTo RefreshErr<br>
adoPrimaryRS.Requery<br>
Exit Sub<br>
RefreshErr:<br>
MsgBox Err.Description<br>
End Sub<br>
----<br>
or<br>
----<br>
Private Sub cmdRefresh_Click()<br>
'This is only needed for multi user apps<br>
On Error GoTo RefreshErr<br>
datPrimaryRS.Refresh<br>
Exit Sub<br>
RefreshErr:<br>
MsgBox Err.Description<br>
End Sub<br>
<br>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.