Your error is here:
Dim myNewEntry As New SqlCommand(("INSERT INTO SCOUTINFO (FIRSTNAME, LASTNAME)
values('" & txtFirstName.Text & "'), ('" & txtLastName.Text & "'"), myConn)
My fix:
Dim myNewEntry As New SqlCommand(("INSERT INTO SCOUTINFO (FIRSTNAME, LASTNAME)
values('" & txtFirstName.Text & "', '" & txtLastName.Text & "')"), myConn)