title: MSAccess event when new record is created
body: <p>I use the current event to update the RecordSource property of a subform based on the ID of the record on the parent form. The problem arises in new records, because the ID field (which is an autonumber) is null. I test for the null ID to avoid errors, but I need to update the RecordSource as soon as the record is created, when the user types the first character.</p>
  
  <p>The problem is that both Dirty and BeforeInsert events are triggered <strong>before</strong> the record is actually created, thus before the ID is assigned. I need an event that will trigger <strong>after</strong> the ID autonumber is assigned.</p>
  
  <p>Thanks in advance for your help</p>