title: New database records not showing until I restart the application
body: <p>I have a problem when I move to the next form, the record that I've just added does not show. For example I typed "123456" then go the next form, and it will just show the previous record, not the "123456".
  It will only show when I stop the program then run it again and the "123456" will show on the second form's textbox.</p>
  
  <p>Form1 code:</p>
  
  <pre><code>Private Sub Command1_Click()
      Form2.Hide
      Form1.Show
      Adodc1.Recordset.Update
  End Sub
  
  Private Sub Form_Load()
      Adodc1.Recordset.AddNew
  End Sub
  </code></pre>
  
  <p>Form2 code:</p>
  
  <pre><code>Private Sub Command1_Click()
      Adodc1.Recordset.Update
  End Sub
  
  Private Sub Form_Load()
      Adodc1.Refresh
      Adodc1.Recordset.MoveLast
  End Sub
  </code></pre>
  
  <p>Does anyone know why it's not showing until I restart?</p>