I have made a smal databas but some where I have got a error
when I add a name surname (jones), forename (roger), phone 34567
it is ok but the problem is that when I edit another one
with same surname(jones) and a different forename (david) same phone
then in the list I press jones the first one it is ok
if I then press the other jones the same jones as the first come up.
Its not an error.
When you edit data your program will edit all record with name 'jones'.
Since you didn't have an key/Id to know which 'jones' to edit.
I suggest you to add Id Column as Key. So you can identifier which record to edit even they have the same name.
Id Surename Forename Phone
1 jones ward 12345
2 jones ward 54321
Even they have same name but you can edit current jones with using their 'Id'.
Dim Adapter As New OleDbDataAdapter
Dim Command As New OleDbCommand
Dim xFrom As String = dtpFrom.Value.ToString.Substring(0, dtpFrom.Value.ToString.IndexOf(" "))
Dim xTo As String = dtpTo.Value.ToString.Substring(0, dtpTo.Value.ToString.IndexOf(" "))
sqlQuery = MainQuery ...