>>>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.
Edward Pikman
Independent Consultant