Welcome to VBForums

Read that line a bit more carefully... here is the SQL statement part with colouring to make it a bit clearer what is a string and what isn't:
Code:
"SELECT est_id FROM ESTUDIANTE WHERE est_nombre =" & 
Val(txtNombre.Text) And "est_apellido =" & Val(txtApellido.Text)
The word And does not belong where it is (it should be inside the string, and that string should be appended to the rest as you do with the other parts).