Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Navigating away from incomplete records (http://www.go4expert.com/forums/navigating-incomplete-records-t17023/)

bonecone 21Apr2009 21:25

Navigating away from incomplete records
 
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 2May2009 00:59

Re: Navigating away from incomplete records
 
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.


All times are GMT +5.5. The time now is 08:29.