BeforeInsert, AfterInsert Events
Applies To
Form.
Description
- 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.
Event | Occurs when |
|
BeforeInsert | User types the first character in a new record. |
BeforeUpdate | User updates the record. |
AfterUpdate | Record is updated. |
AfterInsert | Record updated is a new record. |
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.See Also
BeforeUpdate, AfterUpdate events, Change event, Current event, Delete, BeforeDelConfirm, AfterDelConfirm events, Event properties, GoToRecord action, Open, Close events.