lol
>>>>The displayed value must be in first column... and bound property is use to indicate the column containing the value bound to rowsource... also check the columns count and columns width.
>>>
>>>Well, I think I found why it doesn't work <g> The value I'm using doesn't correspond to the right value. I guess, when my PK is saved to the table it's calculated again and therefore changes again. I thought I fixed the problem, but obviously I fixed it in some other place.
>>What about:
>>with this
>> if .lGetAllCarriers
>> .cboCarriers.rowsource = ''
>> thisform.Carriers_biz1.lRequeryAllCarriers = .t.
>>
>> .lGetAllCarriers = .f.
>>
>> .cboCarriers.rowsourcetype = 6
>> .cboCarriers.rowsource = 'crsCarriers_All.FieldToDisplay,crsCarriers_All_Carriers_pk'
>> .BoundTo = .t.
>> .BoundColumn = 2
>> .cboCarriers.Requery()
>>
>> if not xEmpty(thisform.cSelected_Carriers_pk)
>> .cboCarriers.value = thisform.cSelected_Carriers_pk
>> endif
>> endif
>>endwith
>>
>
>No, thanks <g> I was looking to too many places at once and so I asnwered in your message instead of my own <g>
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.