Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Sep 2015
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Difference between afterupdate and exit

    Hello everyone
    I would like to know the difference between AfterUpdate and Exit events as for TextBox on UserFroms...
    If possible with examples

    I appreciate any help

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    The Exit event is triggered when another control is selected.

    The AfterUpdate event is triggered when a change is made to the control.

    Thus the event chain is: BeforeUpdate (error checking) -> AfterUpdate (things to do after the control changes) -> Exit (what to do when another control is selected).

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    New Lounger
    Join Date
    Sep 2015
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks a lot for help
    Now I got the Exit event and I'm confused with BeforeUpdate and AfterUpdate as these events don't respond unless any change happens

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Quote Originally Posted by YasserKhalil View Post
    Thanks a lot for help
    Now I got the Exit event and I'm confused with BeforeUpdate and AfterUpdate as these events don't respond unless any change happens
    Before Update is used to do error processing on the value in the control and is basically, IMHO, all it should be used for. After Update is used to take action on the new value in the control, e.g. If you selected a State in the control you could now set another control with the Area Codes or Zip Codes used in that state so the user doesn't have to look at ones that don't apply. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  5. #5
    New Lounger
    Join Date
    Sep 2015
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you very much for this great information
    Best Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •