I am using a number of comboboxes within grids in an application I'm trying to finish up. All of them work correctly now with the exception of one. This one (which is coded exactly like some others that do work) drops the correct list and shows the user selection for an instant and then clears and loses it's .Text value. It's RowSourceType is 3 - SQL Statement and the RowSource is a simple select of a column in a table. The ControlSource is a field of another table (the same as the column in the grid that contains this combobox).

I have compared the properties of this combobox with those of others and even have the identical code in another grid with the identical tables used and properties which does work. I have deleted and re-created this combobox with the same results. Where might I look to correct this situation. I am pressed to finish this application and am stuck on this problem.

TIA,
Tom.