Database linking problem.

First of all, I have a problem to display all my records in the database table to the DataCombo list. Eventually, I managed to solve it but here comes a new problem.

I'm doing a sales program. If I select Product 1 from the DataCombo (Which retrieves its list of product names from the database), I am suppose to get the unit price in a textbox names txtUnitPrice. But the unitprice textbox doesn't respond when I select different products from the DataCombo.
The unitprice textbox will respond if I select the product through the adodc instead which I make invisible.

Anyone can help me pls!

:confused:

If only this were VBprogramming.com...

gg