al campagna,
This code prompt me (Yes/ No) even if the data has NO DUPLICATES..

how could i do it, like this:-

if data duplicates= it will Not add the record and the form will return to it
natural state, add new record
if date has NO DUPLICATES= it will add data automatically, withour promp me
any thing ( like noting happen)

your suggestion is much appciated


syedalna wrote:
Al Campagna,

Your code is what i'm looking for.

It did identified the duplication & show the message box of the textbox2...
and ADD the record to the table.. I need to have a "Yes" & "No" on the
message box..where
if "Yes" = it will add the record that enter
if "No"= it will Not add the record and the form will return to it natural
state of Add New Data Entry (Add New Record).

Could you show me the code. I do appreciate it very much.

Thanks for your code

syedalna ,
Use the BeforeUpdate event of TextBox1 to do a Dlookup against all the other
[quoted text clipped - 15 lines]

Thank you in advane

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1