Results 1 to 4 of 4
  1. #1
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581

    Asking to save information

    Is there a simple way to code the exit button to ask if you want to save the information only if there were changes done to the fields?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the system saves when you exit the record.
    nothing to do.

  3. #3
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    Not the way I have it set up. In this particular instance I found it best to use unbound fields and save them to bound fields when I exit. They load up when the form is brought up. I've used this method before and just compared fields. If there were changes, it saved the information. This has too many fields to do that though. Normally I don't do this, but sometimes it's the best way.

  4. #4
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    You would need to set a flag on the form to true based on any updates to any fields.
    On Exit check the flag and either save or don't.

    It's messy with loads of fields, better to use the forms before update event and a bound form.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 12-13-2016, 02:18 PM
  2. Replies: 8
    Last Post: 12-03-2015, 10:18 AM
  3. Replies: 3
    Last Post: 05-02-2014, 09:27 AM
  4. Save date-specific information for a record.
    By billef32 in forum Programming
    Replies: 2
    Last Post: 03-25-2013, 09:48 PM
  5. Replies: 1
    Last Post: 06-28-2012, 09:57 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums