February 14, 200718 yr What is the best way of locking a record so it cannot be modified(text field) that is made on a different date than today. I want to be able to edit and change records made today but not to accidentally modify records made on previous days. This data field is a text field(s) that contain patient data that should be "locked at midnight". thanks, john
February 14, 200718 yr Hi a way is to create a date field (date) with option to auto-enter the date of creation; and to put this calc into validation option of your text field: date = Get ( CurrentDate ) BTW: this isn't the best way, maybe the simplest :)
February 16, 200718 yr Author I was trying to do this with privilege restrictions but using a get command with a calculation may be the best. thanks, john
Create an account or sign in to comment