Hi, I have a form that executes 8 complex queries and put the results in different text boxes. Sometimes when the server runs slow, it takes a very long time to complete all 8 queries and Access won't update the text boxes until all 8 are finished or if a mouse click is detected, it will update the text boxes it has finished. How do I tell Access to update whenever a text box is changed. I'm think I can use the OnChange Event of each text box, but what do I put in it? Many thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Automatic Form refresh
- Thread starter ywenz
- Start date
private sub <textboxnamehere>_OnChange()
<textboxnamehere>.requery
end sub
you could also use the OnDirty event, if you're using a later version of Access (2000 or greater, I think).
HTH
Greg
Boss quote from an office meeting: We're going to continue to have these meetings until we figure out why no work is getting done ...
<textboxnamehere>.requery
end sub
you could also use the OnDirty event, if you're using a later version of Access (2000 or greater, I think).
HTH
Greg
Boss quote from an office meeting: We're going to continue to have these meetings until we figure out why no work is getting done ...
- Status
Similar threads
