Updated Event - Event Procedures

Updated Event — Event Procedures

See Also        

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.