Is it possible to create a SQL select statement which populates the data into selected texboxes ?
I thought of this code but I know it doesn't work and not sure on how to correct it.
Dim cmd As New OleDb.OleDbCommand
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Matthew\SkyDrive\Documents\WORK\main.mdb"
cmd.Connection = con
cmd.CommandText = "Select (Inv_ID, Inv_CustomerName) FROM Invoices WHERE ID='" & TextBox4.Text & "' VALUES('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "')"