Good morning, Back to to the combobox display problem...
I tried Select A + B, A (A is the value, B is the description) with BoundColumn = 2, BoundTo = .T. but no luck. The display in the combo box is still blank. It seems the display is somehow hard-wired to pick up the first column in the SQL result, and if the first column is larger that the ControlSource, then it won't show anything at all. The effect of setting BoundColumn = 2 is to change the combobox.Value to whatever is in column 2. The display itself has a mind of its own.
------------------------------------------------------------------
My closest solution is to use the following combination:
BoundColumn = 1
ColumnCount = 2
Rowsource = "select A,B from .." where A is the value linked with the control source, and B is the description.
After choosing one of the A + B pulldown values, the combobox displays A, where I would prefer it to display A + B. But at least the description B shows in the pulldown where it's most important.
Thank all of you for your help.