title: Entering record to access database from 2nd form vb.net
body: <p>Dear Fellow VB programmers,</p>
  
  <p>i'm currently have a problem adding a new record Ms. Access Database.</p>
  
  <p>basicly, i made 2 forms </p>
  
  <p>these 2 forms accessed the same database</p>
  
  <p>-first form was succeed</p>
  
  <p>-second form was also succeed, but when i check my database, the record from second form was created as new row. i wanted the data recorded in the same row</p>
  
  <p>this is my code</p>
  
  <pre><code>Dim cb As New OleDb.OleDbCommandBuilder(da)
          Dim dsnewrow As DataRow
          dsnewrow = ds.Tables("GuestNumber").NewRow()
          dsnewrow.Item("GuestNumber") = txtGuestNumber.Text
          ds.Tables("GuestNumber").Rows.Add(dsnewrow)
  
          da.Update(ds, "GuestNumber")
  
          MsgBox("New Record added to database")
  
  
          btnAdd.Enabled = True
  </code></pre>
  
  <p>how to deal with this kind of problem? what kind of code shall i use?
  thank you very much </p>