BeforeInsert, AfterInsert Events

See Also                  Macros         Event Procedures         Applies To

• The BeforeInsert event occurs when the user types the first character in a new record, but before the record is actually created.
  
  
• The AfterInsert event occurs after a new record is added.

Note   Setting the value of a control by using a macro or Visual Basic doesn't trigger these events.

Remarks

To run a macro or event procedure when these events occur, set the BeforeInsert or AfterInsert property to the name of the macro or to [Event Procedure].

You can use an AfterInsert event procedure or macro to requery a recordset whenever a new record is added.

The BeforeInsert and AfterInsert events are similar to the BeforeUpdate and AfterUpdate events. These events occur in the following order:

BeforeInsert Þ BeforeUpdate Þ AfterUpdate Þ AfterInsert.

The following table summarizes the interaction between these events.

If the first character in a new record is typed into a text box or combo box, the BeforeInsert event occurs before the Change event.