>>>>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 - :))))))))