>If I remove the ControlSource, then how do I display its value?
>
>>Remove the controlsource, since it is not what you're using.
You're not displaying the value anyway.
I would, actually, do it a bit differently. If you want to use value, then, I think:
RowSource = 'No value,N,My Second Choice,M,My ThirdChoice,T'
RowSourceType = 1 && Value
controlsource = myTable.MyField
BoundColumn = 2
ColumnCount = 2
Something like that. I actually always prefer to use either cursor or an array for my combos, that's why I can not write exactly from the top of my head.
If it's not broken, fix it until it is.
My Blog