Checking for duplicates

How can I check to see if a record already exists in an Access table?

Try to read the database, using what you determine to be a unique key. EOF and BOF will be set to true if there's no match.