Navigating away from incomplete records

bonecone's Avatar, Join Date: Apr 2009
Newbie Member
I'm almost finished with a database program in Access 2007. There's just one more glitch I want to fix.

If I try to insert a new record, but then change my mind before I've filled out all the fields, Access will not allow me to navigate away from the record. It forces me to fill out the rest of the fields and save the record.

How can I get Access to display a Yes/No Prompt warning that the record will be lost, and then allow the user to navigate away from the record if they want?
pete_bisby's Avatar, Join Date: Nov 2007
Go4Expert Member
Are you entering the information directly into the table, or are you using a form?

If you're using a form you can use the "On Undo" event - undoing a helf-entered record, press the Escape key.