how to handle duplicate entry.....
Hello friends I am a beginner in ms access 2010. I need some help. I have a main table called Mailing_Entry_Table in this table I have the following fields: SlNo.(Primery_Key), Dep_Id, M-Date, Cmbo_M-title, Sign, M-Desi, M-Dept, M-Name, Institute, Address1, Address2, City, Pin, Phone. where Cmbo_m_title is a combo box, and the field name is acquired form a different table called Title_Table. Institute is also a combo, where the records are drawn from another table called fulllist (This contains the details of various Institutions, address, Pin and Phone)
I have a form called Maling_Lable_Entry_Form, in this form the date, name, designation department are entered Other fields like initiation name address1, address2, city, pin and the title is drawn from different tables as stated above.
Now, the help I am looking for is: when I enter a data. And press save! Access should check for duplicate entry, if the same name with the title and institution same has already been entered????? If yes give me an option to either save and continue and go the next entry without saving this entry.
How to check this duplicate entry……..
Regards,
Lal