Diff between After Update and On Change?

[CW]

Could somebody kindly explain the detailed differences between these two
events, what they each do (and do not do) and when to use one rather than the
other?
I use After Update quite a lot in my form controls particularly to trigger
changes and calculations in other controls, but sometimes it doesn't seem to
work. This may be caused by the way the user is navigating (despite my
carefully set up tab order) or it may be that I am using the wrong Event.
Many thanks for your advice
CW

 

[CW]

Many thanks John, that helps.
And I guess that if I want to ensure that something fires even if the value
has not been changed, I would use either On Exit or Lost Focus?
Thanks again
CW

 

[CW]

Thanks for the suggestion Pete but unfortunately I get an MS Office Online
error msge "This service is unavailable". I tried a couple of times, a while
apart. Maybe it has iced up...

 

[Clif McIrvin]

Thanks for the suggestion Pete but unfortunately I get an MS Office
Online
error msge "This service is unavailable". I tried a couple of times, a
while
apart. Maybe it has iced up...

Not sure what happened there; but try:
http://office.microsoft.com/en-us/access/HP051867611033.aspx

 

[CW]

Clif - thanks for chipping in with that... yes that link worked fine, very
useful article, thanks again
CW

 

[Pete D.]

Thanks for the help Clif, I must of pushed the mouse backwards or something.

 

[Clif McIrvin]

Thanks for the help Clif, I must of pushed the mouse backwards or
something.

You're welcome.

I was curious myself so I did a bit of looking after I sent off the link
....

A Google search on 867611033.aspx turned up a couple references that had
the full link hidden behind the abbreviated link that you posted. It
appears that you managed to copy / paste a link display text instead of
the link itself.

At any rate, glad I was able to help.

--
Clif

 

[John W. Vinson]

And I guess that if I want to ensure that something fires even if the value
has not been changed, I would use either On Exit or Lost Focus?

Well... what if the user opens the form and never sets focus to that control
at all!?

What's the context? What is this textbox used for, and why do you need to run
code even if the user just *looks at* the textbox?

 

[David W. Fenton]

And I guess that if I want to ensure that something fires even if
the value has not been changed, I would use either On Exit or Lost
Focus?

I would use On Exit, since you could lose focus to a different form
in a case when you didn't want your event to fire yet.