title: Enabling and disabling controls on a Continuous Subform in Access 2007/2010
body: <p>I need to enable or disable a control on a continuous subform, dependent on another field. The initial code I wrote by instinct was very similar to what is suggested <a href="http://www.dbforums.com/microsoft-access/1654808-continuous-form-making-button-visible-invisible.html#post6453487" rel="nofollow">here</a>, but instead of only disabling those controls which are marked as "child", it disables all of them - in effect, it seems only to be looking for the value of the last record and affecting all the rows.</p>
  
  <p>Is there a way this can be achieved, or am I barking up the wrong tree? Code below:</p>
  
  <pre><code>If Me.Record_Type = "Child" Then 'Disable subsidiary records
  Me.Record_Type.SetFocus
  Me.Prospect_Name.Enabled = False
  End If
  </code></pre>