[RESOLVED] Replicating a record issue

:bigyello: :wave: ,

Im using vb6 and have a problem reguarding replicating the same record,
ATM it will allow me to replicate records in the db and I wish to not allow this
and display a message "Employee already Entered" Or "ID already In Use"?
here is my add and function add code
vbcode___________________________
Private Sub cmdAdd_Click()
txtFirstName.Text = vbNullString
txtLastName.Text = vbNullString

list

End Function

Thanks again :thumb:

hi

Before rs.addnew you have to search in the table that is id exist in table or not ?
if exist then give message else add new record

Or u can define primary key in table and do error handling in front end
Or u can also do it in procedures

still not quite right?
anymore sugg?

You should use a Primary Key, a unique identification for all your records so they wouldn't be duplicated...

Thanks again Dee-u for all the help!

No worries. :)