>I've also noticed that the base table almost alway gets updated when i close the form that works with this view.
I am not sure, but this may very well be by design (on purpose). In general, it is not good practice to leave pending changes when closing a form. Before closing your form, you should test for pending changes, ask the user what to do, and then either save all changes or discard all changes.
Ask back if you need the corresponding commands.
Met hartelijke groeten,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)