AfterInsert Event

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

Remarks

You can use an AfterInsert event procedure or macro to requery a recordset whenever a new record is added.