Events Triggered When VBA Changes the Value in A Control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Are any events triggered when a text box control value is changed by VBA
(such as when a text box value, bound to a table, is changed via a FindRecord
command)? All Events I have tried appear to trigger only when a USER changes
the value. I am using Access 2000

Thanks
 
It's real nasty, but I have a timer event wake up and do this type of thing.

Initially, I set the counter at 5 because I want this event to pop right
after the form opens.

Within the timer event, the first thing I do is set the timer to zero. Then
I do whatever processing is necessary. Upon exit, I leave the timer set to
zero.

If I want the code within the timer event to execute, from anywhere within
the application I simply set the timer to 5. This works even if that
particular form is minimized, running hidden, etc.

All my forms are popups (non-modal) and at times I have several either
minimized or running behind other forms so not visible to the user.

This technique has worked well within my application, but I do need to
remember that wherever I am I must set that timer to 5 in order to make that
code wake up.
 
Back
Top