I am using VB6. and Adodc connector. I want to Search any keyword in text boxes. if searching item is written in textbox and on pressing enter it should have to displays related records in other textbox

Example
Text1
Text2
Text3
Text4

Adodc

if i put searching item in text1 and enter butten is pressed. related items should have to display in Text1, Text2, Text3, Text4 from database

i didn't understand where is the problem !

write your code in Text1 Change event and use if for control it

You need SQL statement For that ?? describe where is your problem

thank you

What have you done so far?