Hello Guys I've a question , i've made a small form with data OLEDB Combo box and text box , I've connected my form with Access DB by Adodc tool, now I've school class number and teacher name , i want to select the list item 1 from the combo box and display the teacher for it according to the Database recored, how can i do that ? for example i've Class A , and teacher Name : Bader Class B , and teacher Name : Tom i want to select class A from combo box and show Bader in the text field and ...etc , how i can do it ? ( I've attached my example )