Confirm before update

  • Thread starter Thread starter Jeroen Verdrengh
  • Start date Start date
J

Jeroen Verdrengh

Hi,

How can I ask a user of my access app if he/she is sure before updates via
forms are made persistent? Can I say sth like "abort everything" in the
before-update trigger?

greetings,

Jeroen
 
Two ways:

1. Use unbound forms - this means you will have to add code to write the
data to the tables.
2. Use code in the BeforeUpdate event - you can cancel this event in code
which will stop the data being written. This is OK if you just have a simple
form with no related records in a subform. If you have a subform then the
main record has to be written to the table before you can enter any subform
records, and things get a bit more complicated.
 
Back
Top