BeforeInsert, AfterInsert Events — Event Procedures
Description
To create an event procedure that runs when the BeforeInsert or AfterInsert event occurs, set the BeforeInsert or AfterInsert property to [Event Procedure], and click the Build button.
Syntax
Private Sub Form_BeforeInsert(Cancel As Integer)
Private Sub Form_AfterInsert( )
The BeforeInsert event procedure has the following argument.
| Argument | Description |
|
| Cancel | The setting determines if the BeforeInsert event occurs. Setting the Cancel argument to True (–1) cancels the BeforeInsert event. |
Remarks
You can't cancel the AfterInsert event.
See Also
BeforeInsert, AfterInsert events — macros.
Example
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