Access appears to update records it should not

[DavidAC]

We have a database which when a query is run should update the system with a timestamp when the yes button is pressed on the query. However it appears to be also updating if the no button is pressed even though the message says the system will not be updated.

any help would be appreciated as to why this is occuring, and how we can stop it.

 

[Norie]

yes button is pressed on the query

Do you just mean the button on an Access popup or is it a form from the database?

 

[DavidAC]

the button appears when access is running the query. it is not a button i have created, it comes from the access query.