The combo is unbound. The new record is being added and the caseplanID is generated... the new record shows up in the tables and it shows up in the combo box. However, when you select it in the combo box, the information displayed on the main form and subforms are for the first record ever...
I have a lookup combo box in a main form with the following VBA AfterUpdate:
'Clone the form's table/query into a recordset.
Dim MyRecSet As Object
Set MyRecSet = Me.Recordset.Clone
'Find first matching record in the recordset.
MyRecSet.FindFirst "[CasePlanID] = " &...