hello all,.

i am working on a program that does add, delete, update and find, so far i managed with all except for add,

i have the below code:
Dim strBufferTaper As String

strBufferTaper = txttaper.Text
DataTaperCode.UpdateControls
DataTaperCode.Recordset.AddNew
txttaper.Text = strBufferTaper
DataTaperCode.Recordset.MoveNext
DataTaperCode.Recordset.AddNew

which works fine to add a new record to a table called Taper

how do i enhance this code to check for duplicate in the table before adding the new record, if the record already exist, give a message box, if not, then add the new record from the user input (txttaper.text)

please help

thank you in advance