Difference between afterupdate and exit

Topic

New Reply

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

Reply | Quote

Replies

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 :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

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

Reply | Quote

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 :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Thank you very much for this great information
Best Regards

Reply | Quote