Edit a record

I want to edit a record in my database (which is indexed having unique
fields). But whenever I do so, it gives error of duplicate values.
But I am using data1.recordset.edit, so I guess it shouldn't give
that error. Please guide me in this. It is urgent.

[JimmyT]

This is probably obvious, but if you are trying to edit a field that is required to be unique, you must ensure that you are not setting in an existing value.