AfterInsert Event Access

AfterInsert event occurs in VBA after a new record has been added to the source table of the form.

AfterInsert Event Example:

Here we popup a message to the user when a new record is inserted:

Private Sub Form_AfterInsert()
  MsgBox "The new employee record has been created"
End Sub

Or, requery a combo box after a new entry has been inserted:

Private Sub Form_AfterInsert()
  Form_F_Employees.Department_Combo.Requery
End Sub

Try a running after insert event example here:

Inventory Calculations Example with After Insert Event

Recently added to this demo are complex form footer sum calculations and an example of an after insert (afterinsert) event procedure. ... www.blueclaw-db.com/download/download_inventory_calculations.htm

See the Related BeforeInsert Event in Microsoft Access

BeforeInsert. Filter. Open. BeforeUpdate. Format. Print. DblClick. KeyPress. Unload. Delete. More examples of canceling an event:. Access Undo Event Example ...