Did I really want to update that field !!
Posted on 2011-10-17
This is a slightly unusual high-level question!
I have a database of 5,000 students in a school.
It is mainly just static data, names and addresses etc.
However, the form is often viewed and there is always the danger that the user accidentally changes the "name" of the student or some other field.
I do NOT want to make this form read only.
Question: Is there any easy way I can flag a field so that .... it will give a warning message .. "Did you really want to change that field ? ".
I know how to do this in VBA but I am looking for something simpler (which may not exist!).
Ideally, a "property" that can be set to "Prompt with Warning On Data Change".