Hello every one.
i am trying to catch duplicate values from a data. in the picture when i want to add new record, then if the record already exists then go to that record and fill all the boxes, then i will press the update button,but if not, then add new value. field is indexed.
Capture.JPG ![Capture.JPG]
so how to code that? i need it very much.

i use it because, i want to catch duplicate records and pass its values to textboxes for update.