I have a form that have a combo (combo1) and a grid.

In the grid, I have 5 columns.. the first 2 columns' s currentcontrol is combo called combo2, combo3 and other textbox...

the combo2 is product id, combo3 is product colour, so i want to look for the product id from the combo2.. then the combo3 will display several colour (only for that product id )that i selected from the combo2. then the unit price (for that productid+prodcolour) will come automatically out for the textbox....

i have tried several time.. it failed. it always take the last record' unit price even i choose the first record's productid+prodcolor.

sorry for my english