Applies To
CheckBox control, ComboBox control, ListBox control, OptionButton control, ScrollBar control, SpinButton control, TextBox control, ToggleButton control.
Description
Occurs after data in a control is changed through the user interface.
Syntax
Private Sub object_AfterUpdate( )
The AfterUpdate event syntax has these parts:
Part
Description
object
Required. A valid object.
Remarks
The AfterUpdate event occurs regardless of whether the control is bound (that is, when the RowSource property specifies a data source for the control). This event cannot be canceled. If you want to cancel the update (to restore the previous value of the control), use the BeforeUpdate event and set the Cancel argument to True.
The AfterUpdate event occurs after the BeforeUpdate event and before the Exit event for the current control and before the Enter event for the next control in the tab order.
See Also
BeforeUpdate event, BoundValue property, Change event, RowSource property.