>>>>>>I would like to edit a member of a COMBO BOX and
>>>>>>save the changes to my table. any ideas?
>>>>>
>>>>>Basically, you just edit appropriate field from rowsource (cursor).
>>>>>Why not to make search in UT? You asked this question many times before.
>>>>I am taking about making a change in the combox box value area and
>>>>having that change saved to your table... here is the code I have
>>>>in the VALID event.
>>>>
>>>>replace name with thisform.combo1.displayvalue
>>>>thisform.combo1.requery()
>>>>It is not working...
>>>>The questions I have asked concerning the combo boxz were about adding.
>>>
>>>Well, it's something like this:
>>>*** Combo.InteractiveChange event
>>>if not empty(this.value)
>>> this.tag=table1.name
>>>endif
>>>*** Combo.Lostfocus event
>>>local cDisplayvalue
>>>cDisplayvalue=this.displayvalue
>>>if this.value<>cDisplayvalue
>>> select table1
>>> locate for name=this.tag
>>> replace name with this.displayvalue
>>> this.requery
>>> this.value=cDisplayvalue
>>>endif
>>>this.tag=""
>>>I hope, you use unbound combo.
>>
>>Well Ed - I have to say thank you again. This is what I have done:
>>*** Combo.InteractiveChange event
>> this.tag=mytable.name
>> local cDisplayvalue
>> cDisplayvalue=this.displayvalue
>> if this.value<>cDisplayvalue
>> select mytable
>> locate for name=this.tag
>> replace name with this.displayvalue
>> this.requery
>> endif
>>This works great if you want to edit you combo box without buffering.
>>thanks Ed - :))))))))
>
>Using InteractiveChange only, you will trigger replacing extra times (when user in the middle of editing). It might be Ok for quick test, but in real situation with implemented RI, it could create tremendous overhead. I think Lostfocus is a little bit better, however I'm not sure that the idea to edit combo items on fly is robust at all.

Good Morning Ed - When I use the code in the LostFocus event, it makes the change to the last record and not the record that is the displayvalue.