write conflict error ?

[Miranda]

hi guys,

i've got a form that has a projects name at the top and a button to another
form to change some project details (the first form is closed when the 2nd
form loads)...so i've got an update query to change project details (not
project name). The values are updated in the table correctly. i have a back
button that closes the 2nd form and opens the 1st form again with a where
condition form1.projectname = form2.projectname...but i get a write error
message when form1 is loaded saying that this record has been changed by
another user since you started using it...

any ideas why this is happening? and how to fix it?

thanks
miranda