Hi Car313, and welcome to the forum.....
you can do what you want to but you will need to place some code to run behind the form.
lets asume you are using a checkbox for your value, lets call it ckbAttendsSchool, and another control called say TypeofSchool
if we interogate that value then we can make decisions based on that value
if you are only making a single setting a shorthand to that is
if ckbAttendsSchool.value=true then
however if you are going to set multiple properties at the same time then use the if then else version
TypeofSchool.enabled = ckbAttendsSchool.value
you may need to use the if then else if say you wanted to blank out the typeofschool if the value in attends school changes to false.
so having created the logic we now need to find a place to put it, in what condition do you think might want to set this value.
-when you insert a new record - implement in the forms "beforeinsert" event
-when the value of ckbattendsschool changes - implement in the controls "onchange"
-when you change records - implement in the forms "oncurrent" event
so the next step to enter the code, it could be done as a macro or vb function - the choice is upto you.
I'd rather be riding on the Tiger 800 or the Norton