You want to lock the checkbox field if you're going to show it. No point in having all this prevention if I can (accidentally?) uncheck the box. Checkbox fields for this type of thing provide limited value IMHO. A table field [Status] might be more useful in that you can provide more than 2 possible values: UnApprvd (because it's an unfinished record - I went for lunch or suddenly need more info) Submit (has been sent for approval -assuming all or any had to be approved by a higher authority as a matter of course) Approved (obvious) Reject (obvious). If you took that approach, I'd have a tblStatus so I could choose the status from a combo and not allow mis-typed entries.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.