Lock data using a check box

[gheyman]

Curious if this is possible: If you have a form that shows the fields for a records from a table, can you add a checkbox, either as part of the fields or separate, that when checked keeps the user from changing the data? I'm not necessarily wanting to "Lock" it as I am trying to keep it from being changed by accident.

When the user finishes entering the data, I want them to be able to check a bock to show they are done with it. When someone goes to that record, if the box is checked, I want tot keep them from changing the data. But I also want them to be able to uncheck the box and then change it. So basically its not a lock down as much as a caution and a status.

Hope that makes sense.

 

[mole999]

should be possible. If when you tab away from the field you use VBA to set the lock to on, it would then be set until toggled off

 

[gheyman]

Thanks