record update when I change view

[mdpepper1]

If I am looking at an existing record in form view and alter some information, then change the view to design view, the record is updated with the changes.



Why is this?

How can I stop this update on view change?

I have investigated the 'on view change' event and have not found anything helpful about blocking these updates.

The reason I want to stop them is so that an accidental typing mistake will not enter the database when the user makes a view change.

[Toyman]

Since your form is bound to the table or query, when ever you enter a value into the field and navagate away, the value is entered into the table. That is just the normal way Access works. If you want to have the user click on a Save button before the record is saved, you will need to use unbound forms. The unbound form method takes some coding, and depending on your ability to do coding, you might want to stay with the bound form method