John, thanks for your interest; here it is:

I want to be able to have the order line items in a grid on a form, where the first column of the grid is the product description; when I click on any item on this first column, I want to have have a pick list popup and show me the whole product list on the product table. Once the item is selected, it pulls in the price of the item and the second column prompts the user for a quantity, which is a field of the line item table. The order line item file is buffered and the product list is brought up via SQL-SELECT. So far my lists does all this except that it doesn't hold the description on the grid field when it's selected and the field is abandoned.

Thanks,

Gil

>Gil:
>
>Email me the problem.....I'm kinda confused by what you're trying to do but I'll be glad to do some code-humpin...
>
>John
>
>>
>>I'm not really storing the description, the only values that I'm storing are the product code and product price in my line item file. What I need is to have the combobox bring the value(description) of the product code and populate a line in the grid when I pulled that order, and whenever a select a new value (for new orders)from the combobox, the item I select should stay on the grid line and not disappear as it has been doing.
>>
>>Thanks,
>>
>>Gil
>>
>>>Gil ---
>>>
>>>This *may be* due to an incompatibility between the control source and the the bound data source. I've gotten that when I was selecting a .. lets say ... 50 character value and trying to store it to a 30 char value.....
>>>
>>>It appears to select OK but shows blank....is that the symptom?
>>>
>>>John
>>>
>>>>Hi, were you able to fix the problem you had with using a combobox(dropdown list) in a grid? I have the exact same problem you had at the beginning of the thread and I wonder if you could share the recipe on you got it to work. Whenever I select a product from the list it flashes for about a milisecond and then disappears, giving me the blue background, although I'm able to get the information I need from it such as price and code value, but the description won't stay.
>>>>