Was a zero value being placed into the field? I recently found that to be a problem with the combo box. It shifted records around, as displayed in the combo on the form. The actual values in the table were not changed in the other records, but the combo displayed incorrectly. When I changed the record with the zero, everything was good in the world again. :) I don't know why this happens, maybe it's a bug...or undocumented feature!
Dana
>I have a field "serial_no" in my form.
>This field is also a regular tag in the table.
>In the form there is a command button which allows
>the user to change the value of the serial_no for
>the current displayed record. My problem is when
>the user input a new serial no to replace that
>for the current record, i found that the serial_no
>of the last record in the table got changed instead
>of the current record. The order of the table is
>also out of sequence. I'd suppose my way to handle
>an indexed field as a combobox is not correct. I
>would appreciate any help to get me back to the
>right track.
>
>My table "table1 has serialNo" as tag and buffer_
>mode_override is 1.
>
>The following is the codes in my command
>button click():
>
>DO FORM TakeSerialNo TO sNo
>IF !EMPTY(sNo)
> THISFORM.cbSerialNo.value = ALLTRIM(sNo)
> THISFORM.refresh
>ENDIF
>
>Thank you
>JW
Where's the damned Any Key?...too late