>>John: If I've read the thread correctly, you've checked the value of the txtCustPKey textbox. Is that value in the buffer? If this is the active control when you go to your save procedure (toolbar, button on form, etc.) the txtCustPKey.Value may not be flushed into the buffer. You can check with debug and getfldstate(-1) or several other methods
>>
>>Barbara
>
>Barbara:
>
>YES!!!! You got it for me exactly. The control is invisible--I don't know how else to handle fields that have no specific controls--so it never got focus. I SetFocus() and then LostFocus() before TABLEUPDATE() and it worked like a charm.
>
>THANK YOU a ton for the tip. Three days of frustration have come to an end. I really appreciate it.
>
>John
John, I was trying to set up a memo-edit box which could edited in place or expanded with a right-click, and needed to find a way to save whatever the user had changed before he right-clicked. The following code loop was originally meant for diagnostic work, but actually sent the data to the buffer (as seen by the getfldstate() value changing). Feel free to modify it for your situation.
** loop below sets the getfldstate() flag for changes in the memobox,
** despite there being NO commands inside the if/endif statement
if this.value <> oldval(this.controlsource, thisform.cdbf)
*** thisform.cdbf contains the active table.
*** I use this in case the active table is reset in a combo
*** or valid() method.
endif