Quote Originally Posted by coccoster View Post
101. oCmd_Update.ExecuteNonQuery()
That is because you have not set the CommandText for oCmd_Update

You have set the following only
Code:
oCmd_Select.CommandText = sSQL
and
Code:
Using cmd As OleDbCommand = New OleDbCommand
    cmd.CommandText = _
    <SQL>
    UPDATE CUSTOMER set 
        Surname = ?,
        Given = ?,
        DateOfBirth = ?, 
        Sex = ?,
        Phone = ?,
        Address = ?,
        Suburb = ?,
        State = ?,
        PostCode = ?
    WHERE ID = ?
    </SQL>.Value