AfterUpdate Event

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.