How to Create Greyed out boxes that are only enabled with a Checkmark

[Manweofarda]

Hi everyone, I am not a programmer by any means, just a student who is trying to create an Access database for use in medical research.

So in my form that I am creating I have several YES/NO fields.

I would like to make it so that you can only enable the YES/NO fields:
Prog_2ndline_del11q
Prog_2ndline_del17p
Prog_2ndline_Normal
IF
Prog_2ndline_checkcyto is checked YES on its checkbox.

I tried looking through these forums but some of the questions were similar but not exactly the same as mine and I didn't know where should I be entering the code in addition to if just changing the field name.

Thanks for your help everyone!

[PhilOfWalton]

On the After Update of Prog_2ndline_checkcyto you need

Sub  Prog_2ndline_checkcyto_AfterUpdate
    If Prog_2ndline_checkcyto = True then
        Prog_2ndline_del11q.Locked = True
        Prog_2ndline_del17p.Locked = True
        Prog_2ndline_Normal.Locked = True
    Else
        Prog_2ndline_del11q.Locked = False
        Prog_2ndline_del17p.Locked = False
        Prog_2ndline_Normal.Locked = False
End Sub
 

Phil