I have created serval databases typically used by field personnel for various types of data collection. There have been issues with inadvertently editing data after records have been created. I do not want the record to be completely locked so as to not allow any edits at all but some way to at least alert the user prior to editing.
I tried using the OnObjectModify script trigger but this alerts for every key stroke inculding new records. If this dialog box could pop up not for new records and only after a field has been edited, that would be sufficient.
Another idea I tried to figure out was to use a checkbox to lock the record entirely and the user would have to unselect the checkbox in order to make any edits. However, I could not figure out how to lock all of the fields on the form through this check box. I would also need the checkbox to be reselected after the record has been edited or created.