>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
Could you tell more what are your combos RowSources, and how your tables are organized? Seems like it can't find the selected productid+prodcolor by some reasons and goes to the end of the table.
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison