find duplicates and retrive to that record set in access and vb6

[hefaz]

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]
so how to code that? i need it very much.

[Minimalist]

You shouldn't allow duplicate records in your database. To prevent this use a unique or primary key to avoid this. Anyway, here is a possible solution at stackoverflow:
http://stackoverflow.com/questions/1840782/how-to-find-duplicates-in-recordset-using-vb6

[hefaz]

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