Here is the scenario, we have a standard dropdown list, that is basically an override list (it is only actually dropped down, when they wish to override the standard commission solicitor), now based on the following the commissionable solicitor is taken from one of two places, either from the entry persons USERNO, or from the customers default solicitor. Both of these numbers (actually 4 length character fields) are stored in the COMMSOLSVIEW on our SQL server. The orderview view is simply the current order, or where the previous override, or values have been saved. IE: we have a CUSTOMER VIEW, ORDER VIEW, COMMISSIONABLE SOLICITORS (all the solicitors). We need to either pick and place the ONSCREEN (which is bound to orderview.commsol anyways) value to either the CUSTOMER SOLICITOR, or the USERNO, or OVERRIDE with the one from the DROP DOWN LIST.

(the code below, programmatically assigns it... THIS IS NOT BEING DISPLAYED, unless I setfocus to the dropdown.)

if gbCommissionable=.t. then
xtra.pgfmain.pgorder.xcmbsolicitor.value=gsUsrno
else
xtra.pgfmain.pgorder.xcmbsolicitor.value=custview.solicitor
endif


----
THANKS


>It seems that you have solution: call Thisform.Combo.Value=orderview.commsol programmatically and it will work OK.
>BTW, it's really character (or integer)? I mean in both tables.
>
>>Here are some of the stats on this particular combo/dropdown list...
>>
>>CONTROLSOURCE = orderview.commsol
>>ROUWSOURCE = commsolsview.solno,solname,solteam
>>BOUNDCOLUMN = 1
>>
>>The value is getting set to "0056"
>>The commsolsview.solno does contain "0056"
>>
>>After setting the value, I can make it appear properly simply by setting focus to the object. Then the value appears... Before I setfocus, no appearance of the recently set value, even with a refresh, and lockscreen=.f.
>>
>>Thanks
>>
>>>There are fewo things which should be provided:
>>>1. The value you want to show should be in list portion of the combo.
>>>2. The combo should be properly bound to its rowsource (BoundColumn property).
>>>3. You cannot use the same cursor as both row and controlsource.
>>>4. If all 1-3 are provided, you may set Combo.Value=cMyvalue and see it in the combo text portion.