Unanswered: disabling a control on a subform in continuous view
I have a project form. Each project has one or more agencies displayed on a subform in continuous view. I would like to disable a control B if the control A is equal to "N/A". The problem I am having is when the 1st agency's Control A is set to "N/A" the control B is disabled in all records not just the one that was set to "N/A". Any ideas?
That is correct. This is the way MS Access continuous forms are designed. There is no easy way to set a different property value at the record level on a continuous form short of some very creative programming (which is beyond my ability but maybe someone else would have some suggestions there)
What I've done in the past is use the "On Current" event to dynamically enable and disable the field but not set any visual properties so that the user doesn't see all the fields being disabled.
TIP: "disabling" AND "locking" a field will not change the look of a control where just "disabling" a field will change the look.