That did update the first record of the Product file fine.
BTW - UseSeason is numeric.
>Kenneth,
>I'm going to go on the assumption that your form is opening a table, and not a view. Also, I hope you are doing this on practice data.
>
>Can you drop a commandButton on the form and put the following code in the click() method? Then run the form, and click on the button. Close the form, and manually open the table, and browse it. Did it work? Or did you get an error when you clicked on the button?
>
>
>select product
>goto top
>replace useSeason with "test"
>
>
>
>>In the data envirnoment of the Invoice Header form are 16 tables.
>>The product table is one of them.
>>There is no links between the tables in the data environment window.
>>I did not know the data envirnment opened the table, but I'm not surprised - thanks for that info.
>>
>>The code in the init procedure of the data environment is:
>>
>>Set Deleted On
>>SET CENTURY TO 19 ROLLOVER 50
>>DoDefault()
>>
>>
>>There is no code in any of the procedures for "Cursor9". That is what gets opened when I right click on the "Product" table and select code.
>>
>>Does this shed any light?
>>
___________________________
Kenneth Wonderley
http://www.wonderley.com...the fruit of the Spirit is love, joy, peace, patience, kindness, goodness, faithfulness, gentleness and self-control.
Galatians 5:22 & 23