Hi, I have a primary key field. but whenever i enter the same details twice in that field it doesnt give me an message telling me that i have entered the same detail twice, as this field must be unique, instead it closes the form and does not save. Is there anyway i can get the database to prompt me with a message telling me that i have allready entered the same detail before? let me know if any other details is needed. Thanks in advanced.