title: Row gets modified when form is opened in access vba
body: <p>I need to prepare a screen that will work as a comments screen as used on Facebook. I have to prepare it on access form. Where User will enter the comments and the same should get stored in a table with PartNumber and ItemNumber. Also the recent Comments should be displayed on the same form.</p>
  
  <p>I have prepared a form having Recordsource as my table where the comments needs to be saved. And written a click event where as user clicks the button the comments will get saved in table. But the prob is that without clicking that button if i type values in textbox and close the form still the table gets updated with value before click. Below is the code</p>
  
  <pre><code>Private Sub Post_cmnt_Click() 
      Me.RecordSource = "Part_GeneralPartComment" 
      Call FromForm_Add 
  End Sub
  </code></pre>