Since you are using an Edit button, I would lock the record in the Click() event of the button and refresh the controls on the form.

HTH

---

>I am however concerned that if user A updates the changes before user B changes a field, no error will occur. In this case user B will have no idea that the record he is changing has already been changed by someone else.
>
>Does anyone have a way to deal with this?