Close or update - complete control of bound form (1 Viewer)

Status
Not open for further replies.

spikepl

Eledittingent Beliped
Local time
Today, 13:05
Joined
Nov 3, 2010
Messages
6,142
Many shy away from bound forms because they feel they cannot control updates of the bound record, if they wish to discard data. Unfortunately a lot of incorrect information is floating around the web - these things are FULLY controllable, no matter what you might google.

Attached is an example DB in A2007, which shows complete control over updating of a bound form: it simply asks the user what to do in each case. The user can save the changes and exit, discard the changes and exit, or simply cancel the save.

This happens no matter how you close the form:
  1. By dedicated button
  2. By X in the corner of the form
  3. By closing the entire Access application
 

Attachments

  • PreventClose3.accdb
    484 KB · Views: 991
Last edited:

NauticalGent

Ignore List Poster Boy
Local time
Today, 07:05
Joined
Apr 27, 2015
Messages
6,321
Exactly what I was looking for, awesome utility. Thanks for sharing!
 
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom