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?
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.
