Permanently Locking a Record

[cdacey]

Hi,
I am trying to place a command button on a form that will "Lock" the record. By that I mean the specific record can never be edited or deleted again. I know I can set the form properties to do this but the problem there is once you tab to the next field you can no longer edit the previous field. I would like the ability to review the form, make final cahnages, and then "lock" it. This is a Medical Record database, so you can see the need to have an un-alterable record once the doctor signs off on the record. I am not sure if this is the proper terminology, since I know the term "record lock" is used in a record access networking sense.

Any thoughts ??
Thanks !

 

[FoFa]

You would have do something like set a Y/N field to true which means the record is locked, than check for that in your form and set the fields to locked.

 

[cdacey]

FoFa,

I actually have an MD Sign-off field (yes/no), that the doctor needs to check off when complete. I use this to provide a count of "open" chart notes. I am just not sure how this would relate to locking the rest of the fields. In concept, your saying if that field is checked, then lock all fields in this particular record, which is just what I want to do. But where do I do that, is there a command for locking all fields in a specific record ?

Thansk Chris

 

[neileg]

I would worry that what was locked could become unlocked! I think I'd be tempted to move the locked records to a different table, and allow read only access to this table. If you need to bring together the locked and open records together for reporting, you could use a union query.

 

[cdacey]

Pat,

Thanks, that is what I was looking for. The second table is an option, but would require some major work in regard to new forms, queries, reports, etc...
Thanks Again,
Chris