Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Close a Form Without Saving the Data (Access 2003)

    Hello,

    I am developing a small application with access, and I need to give the user the opportunity to close a form without saving any of the data that they may have already input.

    I tried the DoCmd.Close command, but it saves the data.

    Any Suggestions.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Close a Form Without Saving the Data (Access 2003)

    Access saves the data automatically. How do you intend to determine whether they want to save the data or not when they close the form? A Me.Undo if the form is dirty will roll back the entry, but you would first need to ask the user if he wants to save the data.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •