In your update statement try to use local variables instead of form's properties. Also try to re-index this table first.
>Yes, but I get the "uniqueness is violate" error message. That is the part I am trying to understand since I am not changing the key fields. The site code is different.
>
If it's not broken, fix it until it is.
My Blog