I have a database that is used by half a dozen users and reviewed by one. One of the fields in most of the tables is a Yes/No control field called "New/Edited". This field is not visible in the forms that the users have access to and defaults to "Yes". This way if a new record is created, the admin sees it, reviews it, and then unchecks it.
What I am trying to do is make it so that if a previously reviewed record is altered in a form, it will automatically change the value of that field back to "Yes", so that the admin knows there is a change that may need to be reviewed.
I have fumbled around witht he expressions, macro, and code builder and did little more than confuse myself. Any help anyone could offer would be greatly appreciated.
What I am trying to do is make it so that if a previously reviewed record is altered in a form, it will automatically change the value of that field back to "Yes", so that the admin knows there is a change that may need to be reviewed.
I have fumbled around witht he expressions, macro, and code builder and did little more than confuse myself. Any help anyone could offer would be greatly appreciated.