>Thanks Al,
>
>I have tried it with tablerevert but it still is saving to the table. The control sources of my textboxes on the form are the table and the corresponding fields. This is the code I have in my cancel button now.
>
>set multilocks on
>= cursorsetprop('buffering', 5, 'centhead')
>tablerevert(.T.)
>go prevrec
>thisform.refresh
>
>Any more ideas as to why it's saving to the table?
>
>Thanks,
>Tyler
You need to take a closer look at buffering and how it works with TABLEUPDATE() and TABLEREVERT(). In a nutshell, you make sure buffering is turned on BEFORE you do your edits; that way you're working with a copy of your table's fields, not the values themselves. You can then choose to save the changes with TABLEUPDATE(), or discard them with TABLEREVERT().
Check out the references I gave you earlier.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up