No events are fired by the value in the control changing by moving to a
different record, requerying the recordset, or if the value is changed
programmatically. Some Text Box events fire when the user navigates to the
control like the Got focust, etc. and some only fire when the value changes.
Here are some examples.
Change event - Fires each time a character is typed into the control. For
example if I enter my first name, it would be:
D
Change event
A
Change event
V
Change event
E
Change event
Then when the user tabs out in you will get the Before Update event, After
Update Event and Lost Focus (I may be wrong about when the Lost Focus fires,
but I am sure someone will correct me if I am wrong)
Now, rather than focus on a HOW TO, describe what you are trying to do, and
I am sure we can help with the HOW TO.