Activate/deactivate fields on Form

J

JudyHNM

I have a data entry form. There are some fields on the form that I would
like to open for data entry if a certain box is checked and keep them
"closed" if the box is not checked. How do I do that?

Thanks, Judy
 
K

kingston via AccessMonster.com

With the trigger control's After Update event, use the following:

Me.OtherControl.Enabled = True or False
You might also consider the properties .Visible and .Locked
 
J

JudyHNM

Thank you very much -- I knew it was something straightforward, but I just
could not find it anywhere!! Thanks
 
Top