hi, im my database there are COUNTRY NAMES and its CAPITAL, my problem is using adodc1.recordset if i selected a country in combo1 the label1.caption beside the combo1 will change into its capital.
example
Combo1[PHILIPPINES] : Label1[MANILA]
can u help me thanks advance :)