delete a record when a copy is submitted

I'm not sure what 'copy of it is submitted' means. If you are talking about a duplicate record you can implement BeforeAdd event to check for duplicate and either prevent new record from being added or delete existing one.

You got it. If an entry is copied, I want to delete the existing record if the job name matches. I found the code that you referred to. here is what I got. I changed the table name and field to check. I'm not sure about the rest. I need to have the system check the table's JobName against the JobName in the form. If they match, delete the existing record. if they do not match, then just enter the record.
'** Check if specific record exists ****

dim rsExists

set rsExists = dal.GlobalTalentJobArchive.Query("JobName='AnyValue'","")

if not rsExists.eof then

' if record exists do something
else

' if dont exist do something else
end if

rsExists.Close : set rsExists = Nothing

Try something along these lines. I asusme that you put this code to BeforeAdd event.

Thank you.