BeforeCommitTransaction Property

Microsoft Access Visual Basic

Show All

BeforeCommitTransaction Property

       

Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the BeforeCommitTransaction event occurs. Read/write.

expression.BeforeCommitTransaction

expression   Required. An expression that returns one of the objects in the Applies To list.

Remarks

This event applies to Access project forms whose BatchUpdates properties are set to True.

Valid values for this property are "macroname" where macroname is the name of macro, "[Event Procedure]" which indicates the event procedure associated with the BeforeCommitTransaction event for the specified object, or "=functionname()" where functionname is the name of a user-defined function. For a more detailed discussion of event properties, see "Event Properties."

Example

The following example specifies that when the BeforeCommitTransaction event occurs on the first form of the current project, the associated event procedure should run.

Forms(0).BeforeCommitTransaction = "[Event Procedure]"