Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Form.AfterInsert Event (Access)
Collapse the table of content
Expand the table of content

Form.AfterInsert Event (Access)

The AfterInsert event occurs after a new record is added.

expression .AfterInsert

expression A variable that represents a Form object.

Return Value

nothing

Note Note

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

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].

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
Show:
© 2015 Microsoft