Jdugan4

I have an Access database with a contacts table and a location table that is linked to contacts. When i click the add button I want to add a new contact and add that contacts ID to a the location table. The ID is an Autonumber, so when i add …

Here's the code: [code] Private Sub btdAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btdAdd.Click 'Sets up the connection to the database 'Dim myConn As New OleDb.OleDbConnection() 'Dim sql As String con.Open() Dim cmd As New OleDb.OleDbCommand ("INSERT INTO Contacts(Company, First, Last, Title, Address, City, State," & _ "ZipCode, …