There must be a simple solution to my problem, but I am at a loss to find it!

Two tables - LINE stores data about each line with a numeric value to for the Ink Color selected in the comob box. INK stores the description of the ink colors and the color id.

My goal is to have a combobox in a grid which displays the descriptive value (color) from a second table (RowSource: ink.color, colorid) while storing only the colorid in the ControlSource (line.inkcolor).

My problem is that when the combobox does not have the focus, the ControlSource (line.inkcolor) is displayed -- this is a numeric value that is useless to the user. Once you click on the combo box, the long description is displayed (as the RowSource is ink.color, colorid). The ink.color description is displayed AFTER you make a choice, but as soon as the column loses focus, only the line.inkcolor is displayed again.

I added a regular combobox to the form outside the grid and it works exactly right with the same options selected. Am I missing something in the column or header options? I am only changing values in the combobox settings. The column.ContolSource is also set to line.inkcolor. If I delete this value, random information changes in other columns in my grid...

Any help or insight would be greatly appreciated!

Bly