How can I prevent old records from being modified on a form?
Posted on 2006-06-14
This database is used as an electronic timecard. Each record in the Work table contains how many hours a person worked on a certain date.
On the form used for entering data into this table, I would like to prevent an existing record from being modified it is over a week old. This is so that after payroll is complete for that week the data can't be changed. I would prefer to somehow lock the records in the table itself but I understand that's impossible.
Also, on a side note, is there an easy way to include a field in the table that would be automatically updated with the latest time/date that the record was modified?
Thanks for your help.