1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Navigating away from incomplete records

Discussion in 'MS Access' started by bonecone, Apr 21, 2009.

  1. bonecone

    bonecone New 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?
  2. pete_bisby

    pete_bisby New 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.

Share This Page