>David-
>
>Is there only one table involved? More? Relations? A parameterized view? Is the errant textbox showing the next or last record?
There are two tables. The primary table is the work order table. There is an operation table (two field table that maps operation codes to operation descriptions). The work order table is related to the operation table with an opcode field. I use this in a combolist to allow the user to select from a list of options that may apply to a work order. I also have a combolist that selects from an array of text options to fill one of the workorder fields. (Three combolists, the primary keylist and two that select values for specified fields).
No parameterized view.
The errant textbox seems to be showing the next record (where next is determined by the index order of the table).
Everthing about the tables is set up in the DE except that I do not autoopen the tables. This is so that I can specify the database to be used at run time.
In the LOAD I set the table's cursor's DB to my.dbc then fire the DE.opentables.
>
>What is your refresh code?
LOCAL lcproc
lcproc = SET("procedure")
SET PROCEDURE TO UTILS.PRG ADDITIVE
dodefault()
THISFORM.txtqtyinproc.valid
THISFORM.txtihcdate.valid
IF alltrim(THISFORM.txtcomment.value) <> alltrim(wojrn.comment)
ibox("Houston, we have a problem")
ENDIF
SET PROCEDURE TO &lcproc
>
>Is the rowsource for the CBO the same as the source for the textboxes?
If you mean is the rowsource for the CBO the same as the controlsource for the textboxes the answer is yes, same alias. However, the rowsource only specifies the key field.
I notice that the interactivechange event does not fire when I use an ENTER while the combo's text field is selected, and this is the only event in which I force a refresh. I guess I could put a refresh in the programmatic change event though as far know, I can only change the combo's value interactively.
"The Iron Fish: The water is cold...but the fish don't mind"
...Jay Jenks, boyhood chum