By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 900 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

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

P: 1
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!
Mar 17 '17 #1
Share this Question
Share on Google+
1 Reply


PhilOfWalton
Expert 100+
P: 1,430
On the After Update of Prog_2ndline_checkcyto you need

Expand|Select|Wrap|Line Numbers
  1. Sub  Prog_2ndline_checkcyto_AfterUpdate
  2.     If Prog_2ndline_checkcyto = True then
  3.         Prog_2ndline_del11q.Locked = True
  4.         Prog_2ndline_del17p.Locked = True
  5.         Prog_2ndline_Normal.Locked = True
  6.     Else
  7.         Prog_2ndline_del11q.Locked = False
  8.         Prog_2ndline_del17p.Locked = False
  9.         Prog_2ndline_Normal.Locked = False
  10. End Sub
  11.  
Phil
Mar 19 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.