>>Thanks Jim.
>>
>>OK, I set the BoundTo to .T. and the default value shows correctly. Now when I select another value in the Combo, the displayvalue is blank. If I change the BoundTo to .F. after the initial Combo.Requery, the display is correct. I shouldn't have to switch the BoundTo property on and off programmatically, should I.
>>
>>What am I missing?
>>
>>TIA
>>
>>Rex
>
>Rex,
>
>The displayvalue will be blank when the value and the controlsource don't match each other. Check to be sure you have the BoundColumn set correctly and the ColumnCount.
BoundTo allows to match a key, but combo still wants to represent it as character, not as integer, i.e. it's still possible to have mismatch between controlsource and value.
Edward Pikman
Independent Consultant