Updated Event -- Event Procedures

Updated Event — Event Procedures

Description

To create an event procedure that runs when the Updated event occurs, set the OnUpdated property to [Event Procedure], and click the Build button.

Syntax

Private Sub controlname_Updated(Code As Integer)

The Updated event procedure has the following arguments.

Argument	Description

controlname	The name of the control whose Updated event procedure you want to run.
Code	The setting indicates how the OLE object was updated. The Code argument can be one of the following intrinsic constants:
	Constant	Description

	acOLEChanged	Indicates that the object's data has changed.
	acOLESaved	Indicates that the object's data has been saved by the application that created the object. This usually occurs when the user clicks the application's Update command or whatever command is used for updating.
	acOLEClosed	Indicates that the file containing the object's data has been closed by the application that created the object.
	acOLERenamed	Indicates that the file containing the object's data has been renamed by the application that created the object.

Remarks

To see if an object's data has been changed since it was last saved, set a public variable in the Updated event procedure indicating that the object needs to be saved. When you save the OLE object, reset the variable.

You can't cancel the Updated event.