Wouldn't you need to search the second table for the value, if it exists, then save it to the first table?

Eg query:

SELECT * FROM TableValues WHERE FieldName = 'FindThisValue'

So...

Data1.RecordSource = strQRY

If Data1.Recordset.RecordCount = 0 Then

'// Doesn't exist so don't save it

Else

'// It exists in the values table, so we can now save it

End If