i can get the data como to connect to the adodc and it has a drop down list with the values of a column of the table. all ok but when i select any one value i want the record to be moved to that that is i want the form to display the details of the id i selected from the data combo.i am using ado.now when i select any value with data combo it is just selected and the other fields in the form do not display the other details of the value selected