Block fields in Subforms in MS Access

Question

I have the following form with a Subform:

And I need to enable Check in "Approve3" and lock the other fields, but I can only get "LOCK" all or none, how can I go around? Maybe by flying in? I remember it’s a subform inside a form

Answer 1

Using conditional formatting you can lock/enable a field from a criterion:

https://support.office.com/pt-br/article/Alterar-a-apar%C3%Aancia-de-um-controle-usando-a-formata%C3%A7%C3%A3o-condicional-6ba9e9fa-4347-4183-b335-44e43b05e22f