So, I'm trying to figure this one out. If a record exists, I want it to recall the existing record and have it populate the field. If it doesn't, I want it to automatically write those fields to the new table.
Private Sub LP__BeforeUpdate(Cancel As Integer)
Dim db As Database, tb As Recordset...