title: How to update all rows in subform
body: <p>I'm trying to update a field in a sub form based on a factor from the main form however only one record is being updated. My code is:</p>
  
  <pre><code>Private Sub Text54_AfterUpdate()
  Me.pack_details![Text64] = Me.pack_details![Text68] * 1.07 / Me![xchange_rate] 
  End Sub
  </code></pre>
  
  <p>How would I make this apply to all the rows in the sub form? Thanks</p>