Answer 1

i would use access instead of excel. but to answer your question. create an sql query that searches your dataset for a duplicate entry before the new data is commited from the form.