MS Access 2003 Options | Edit Find Confirm Record Changes doesn't

[John sd]

The MS Access 2003 Options | Edit Find Confirm Record Changes doesn't work.

It should work: so that if ever a record is modified, the user is prompted
to confirm those changes.

What is the best workaround for this so that record changes can be confirmed
prior to being comitted ?
Thank you,

 

[Jerry Whittle]

1. Allow users to only see the records through a form. Do not allow them to
get directly into tables or queries.

2. In the form use an even like On Dirty to create see if a record has been
modified then bring up a message box to confirm the change.

 

[John sd]

Thank you, Jerry.
I know this can be code - but should not the option made this change
universally and automatically, rather than having to place code in the form ?
What other purpose does this option serve?

Thank you,