I am using the AfterInsert event to add values to a new record as it is created.
Private Sub Form_AfterInsert()
Me.tbSpecialOrderID = Me.Parent.tbSpecialOrderID
Me.tbStatus = Me.Parent.tbStatus
It works, adding the values correctly. However, it has a small side effect that I want to fix. In order to switch to another record, I need to click twice to unselect the new record. Is there a better event than AfterInsert that will add these values but not require the 2 clicks to get off the record?