I have a large table I am working on for work, I am very familiar with Microsoft Access but I am a novice with programming. I need to find a way for someone in the table to check mark a box called "No Work" that will make the entire record unable to be edited. (I also need a fail safe that an administrator would be able to go in and change this if it gets checked on accident).
We have "Company", "Address", "Contact", "Phone Number", etc. and if it is a customer we no longer wish to work for I need something to automatically run when you open the database table that will not allow the records checked yes to be edited. If any one can help me write a code (as well as how to use it in Access I would be extremely grateful) Please let me know if you have any questions from me that could help, thank you!
We have "Company", "Address", "Contact", "Phone Number", etc. and if it is a customer we no longer wish to work for I need something to automatically run when you open the database table that will not allow the records checked yes to be edited. If any one can help me write a code (as well as how to use it in Access I would be extremely grateful) Please let me know if you have any questions from me that could help, thank you!