your description really make us headache lol, not by the request, but the grammar, and word...
ok, first thing to do, you need to use me.control.enable = false to disable a field. then you said, when you tick a checkbox, it'll disable a field ? then just set onclick event tickbox
-
private sub name_onclick()
-
if me.checkbox = true then
-
me.nameOfControl.Enable = false
-
me.refresh
-
else
-
me.nameofcontrol.enable = true
-
me.nameofcontrol.requery
-
end if
-
end sub
-