AfterInsert Event [Access 2003 VBA Language Reference]
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.
Private Sub Form_AfterInsert()**
You can use an AfterInsert event procedure or macro to requery a recordset whenever a new record is added.
To run a macro or event procedure when the AfterInsert event occurs, set the OnAfterInsert property to the name of the macro or to [Event Procedure].
You can use these macros to display messages or useful information. For example, you can have the BeforeInsert macro display data the user needs when entering a new record.
You can use the CancelEvent action in a BeforeInsert macro to cancel the creation of the new record. When you use the CancelEvent action in a BeforeInsert macro, the focus returns to the new record, which is blank (the character that the user typed is deleted).
You can't use the CancelEvent action in an AfterInsert macro.
This example shows how you can use a BeforeInsert event procedure to verify that the user wants to create a new record, and an AfterInsert event procedure to requery the record source for the Employees form after a record has been added.
To try the example, add the following event procedure to a form named Employees that is based on a table or query. Switch to form Datasheet view and try to insert a record.
Private Sub Form_BeforeInsert(Cancel As Integer) If MsgBox("Insert new record here?", _ vbOKCancel) = vbCancel Then Cancel = True End If End Sub Private Sub Form_AfterInsert() Forms!Employees.Requery End Sub
Applies to | Form Object