I'm glad you got it working.

By the way, this code:

vb.net Code:
  1. TA.InsertNewCustomer(cboFirstName.Text, cboLastName.Text, txtCustBusiness.Text, txtAddress1.Text, txtAddress2.Text, txtCity.Text, txtState.Text, txtZip.Text, txtCustPhone_Home.Text, _
  2.                                                         txtCustPhone_Cell.Text, txtCustPhone_Work.Text, txtExt.Text, txtEmail.Text, txtCustNotes.Text, TE)

Just calls a method of your table adapter. It's not something magical that you just send it random data and it produces your desired output. The method it what I was interested in. The code you have provided simply declares your table adapter and then calls a method. There is more to it than that.

Are you using a 3rd party library for your SQL functions? That would explain why you don't see what I am getting at...