I have a Datacombo which is filled with items from a ADO data source/connection/ SQL command.

I what to have a text box which displays a corresponding field. ie ... from the same record from which the item selected in the text box originates.

I want to text in the text box to change to corresponding field value when the user selects a different item from the datacombo box.

Any help would be greatful... Have a feeling a need a data control but am unsure how datacombo and text box should be connected to this

Cheers

Jonny