This looks so simple, but duH.

I have 2 tables New-Products and Products-List, they both have a field called Codes in them

In the update form I have a field that uses a combobox of "Items" from Products-List, when the user selects an item, it triggers an AfterUpdateEvent.
this is where I have trouble, how do I get the selected "Codes" value from Products-List table to update the "Codes" field in New-Products???

I tried this, but get errors... "Can't find the field '|' referred to in expression.

Private Sub Product_AfterUpdate()

[New-Products]![Codes] = [Product-List]![Codes]

End Sub

thanks,