I need to enable or disable the control in a continuous subordinate form depending on another field. The initial code that I wrote by instinct is very similar to what is offered here , but instead of disabling only those controls that are marked as "children", it disables all of them - in fact, it seems that it is only looking for value of the last record and affects all rows.
Is there a way this can be achieved, or am I barking the wrong tree? Code below:
If Me.Record_Type = "Child" Then 'Disable subsidiary records
Me.Record_Type.SetFocus
Me.Prospect_Name.Enabled = False
End If
source
share