1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Navigating away from incomplete records

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

  1. bonecone

    bonecone New Member

    Joined:
    Apr 21, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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

    Joined:
    Nov 11, 2007
    Messages:
    48
    Likes Received:
    2
    Trophy Points:
    0
    Occupation:
    Software Developer/Analyst, PB
    Location:
    Manchester, England
    Home Page:
    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