check if new item is allready in a table

[bubani]

hmm, thanx but now an error appears:

The Component FROM contains a syntaxerror?

and the next line is colored yellow:

rst.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockOptimistic

Can you do something with that?

But till now, thnx for the help