title: Creating a new record, then focusing on the new record
body: <p>So far I have the following code on a button click event:</p>
  
  <pre><code>        string AccRef = Microsoft.VisualBasic.Interaction.InputBox("New Customer", "Customer Reference:", "", 0, 0);
  
          if (AccRef != "")
          {
              DataRow dr = dSSystem.Customers.NewRow();
              dr["AccRef"] = AccRef;
              dSSystem.Customers.Rows.Add(dr);
  
  
              frmCustomer frmCust = new frmCustomer();
              frmCust.ShowDialog();
  
              this.customersTableAdapter.Fill(this.dSSystem.Customers);
          }
  </code></pre>
  
  <p>This successfully creates a new row as I can see behind the dialogue, however, I have an issue - the dialog that displays is another form that displays all the customer information, this is handled with text boxes having a data binding to the appropriate fields within the database, so naturally they display the information on the selected record within the DB, at the moment however it's showing the information for the previously selected record and not moving to the one created using the code above.</p>
  
  <p>How do I make the system create a new row and then focus on the new row before opening the new form for editing?</p>
  
  <p>Thank you in advance.</p>