Hi everyone. Please I'd like to know if anybody has encountered this problem before. Here's the scenario. I've got a datagrid view Bthat is a child table from another table A. one of the fields is the productID which I have bounded to the Product Table to display the name of the product rather than the ID. What I want to achieve right now is if a new record is created I want on click for the price column to populate after the product has been selected. Below is a similar case using NorthWind database in Access. Any help will be greatly appreciated.

Use the SelectedItemChanged on the combo to cath the new selection. Then modify the Unit cost according.

Hope this helps

Hi Lolafuertes,

I have resolved the problem by using the CellBeginEdit_Click Event. Thanks for your response. Was much appreciated.