That is why, Access ALWAYS attempts to save a dirty record when you close a form or do certain other things that make the dirty record lose focus. It is much harder as newcomers soon find out to stop Access from saving data than to actually save it The form's BeforeUpdate is the key to the whole issue. In this event, you validate data. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.