title: How to lock specific rows in a subform when a form loads?
body: <p>I have a subform containing records with a Yes/No field displayed as a checkbox on the subform.  When the main form is loaded, I need to lock all checked fields so that the user cannot undo what a previous user did: they should only be able to check/uncheck the boxes that were unchecked at the start of thier session. </p>
  
  <p>Is it possible to iterate through all the records in a subform and lock the records selectively based on the field value when a form is loaded? </p>
  
  <p>I know I can put something like </p>
  
  <pre><code>If (Me.chkItemReceived.Value = -1) Then
          Me.chkItemReceived.Locked = True
  Else
          Me.chkItemReceived.Locked = False
  End If
  </code></pre>
  
  <p>in the subform OnCurrent event but this prevents the user from unchecking a box they may have checked accidently.  I can iterate through the records on the subform but can't figure out how to lock the records at row-level.</p>
  
  <p>My other solution is to split the form into two subforms of course - items checked vs. items not but would rather keep it to the one form.</p>
  
  <p>Thanks for your help!</p>