Save Record Warning on Form

[Terry DeJournett]

Is it possible to have a "Save Record" button on a form and the user MUST
press this button or the data will not be saved to the table. That is if a
user makes changes to a record displayed on a form and then changes their
mind, that unless they hit the "Save Record" button, these changes they made
will be ignored?

Thanks,

 

[Douglas J. Steele]

Yes, it's possible.

One way would be to put code into the form's BeforeUpdate event, checking to
see whether the button was pushed or not (you can have a form-level global
variable that the button sets to True, and the Current event sets to False
every time you move to a new record)

Another is to have unbound forms (my usual approach)