title: MS Access FIlter on subform changing values of other fields
body: <p>I have a datasheet subform with a combobox name Loan_ID_cbo. Whenever I update the filter via the combobox, the subform is updating the Loan ID (primary key) with the selected Laon ID from the subform, thereby changing the data on the table.</p>
  
  <p>I would like to only filter this data and not allow the filter to edit the data on the table. How can I prevent this from happening?</p>
  
  <p>Here is my VBA code for the After_Update event:</p>
  
  <pre><code>Private Sub Loan_ID_cbo_AfterUpdate()
  
  Application.Echo False
  
  Me.Filter = "MyKey = '" &amp; Loan_ID_cbo &amp; "'"
  Me.FilterOn = True
  
  If Loan_ID_cbo = "" Then
      Me.Filter = ""
      Me.FilterOn = False
  End If
  
  Application.Echo True
  
  End Sub
  </code></pre>