>Barbara,
>Thanks so much for your answer. If I may, I have a few questions more ( see below)
Dan,
You're welcome :-)
About the lookup: In the LostFocus of the textbox in the part # grid column, you could do a lookup of the part # (usually just a SEEK) and then replace the Part Description value with the correct one. Do a refresh for this column so it shows, and you should be OK.
HTH
Barbara
>The first field in my grid (tr_no) fills in correctly when adding a record, but I have been unsucessful in getting the descption field, cost, etc (from the Parts table to fill in. Column 2 of my grid isnt a combo box, but simply a user fill-in field for the part_no which should drive the remaining fields, all from the parts table). I have tried setting the controlsource for these fields to the Parts table, but it doesnt work. BTW, in what function area of the grid or column should I issue a refresh command? I have tried almost all of them.
>>
>
>>However, if you want to do a lookup, then you can put it in the lostfocus of the combo box where you choose the part #.
>>
>Can you explain more about what you mean by a "lookup"???
>
>Thanks
>Dan