Hello all,
I am new to Access but with that i side i want to learn. I have created a Database that collates defects. The Primary key is called "DefectID" which takes its number from a defect form that is never repeated. Unfortunately ever so often a person will try and input the same defect twice, it goes without saying this would not be allowed as it is set it not allow duplicate entries. My question is, is there a way to create my own message box to pop up when this is attempted?
I am new to Access but with that i side i want to learn. I have created a Database that collates defects. The Primary key is called "DefectID" which takes its number from a defect form that is never repeated. Unfortunately ever so often a person will try and input the same defect twice, it goes without saying this would not be allowed as it is set it not allow duplicate entries. My question is, is there a way to create my own message box to pop up when this is attempted?