Protect Data

[Parra]

How can I protect data in a form once it is entered.

Lets say in a form I go back to a record, the data can easily be changed or manipulated.

How can I have a message pop up and say, the record has changed, do you want to save the changes? Yes / No.

Thanks
Parra

 

[bat17]

You could use the afterupdate event of the form to catch changes.
Another option would be to disable all controls unless you are on a new record and add a button to allow edits.

HTH

Peter