Hi Jimmy.

>> Then I set the properties, Column1.currentcontrol = Combo1, column1.Combo1.RowSource = SELECT stocknum from tomparco!inventory into stock_id, and RowSourceType = 3. I set RecordSource and ColumnSource programmatically in a method called grid_controls:


THISFORM.Grid1.RecordSource = 'trans_items'
ThisFORM.Grid1.Column1.ControlSource = 'trans_items.item_status' <<

Yoy say the combo changes the product ID, but column 1 of your grid is bound to something called item_status. I am a bit confused here.

Off the top of my head, you may want to make sure that the combo's style is 2-DropDown list.

Marcia