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
I'm assuming you set the RowSource prorperty to adodc to get the values into the drop down list.
Set the BoundColumn property on the DataCombo to your primary key, and make sure the DataSource property is empty.
Then edit the Change event for the DataCombo, and type:
Sub DataCombo_Change
adodc.Recordset.Find "PrimaryKey = " & DataCombo.BoundText
End Sub
The DataCombo is usually used the other way around - to edit a field from the Recordset, using values taken from another recordset. On that case, the RowSource and ListField properties would be taken from another adodc, and the DataSource and DataField would be taken from the adodc you're working on.