Try these things:
1. Make sure the view is updateable. Check the Update Criteria page of the View Designer. Make sure Send SQL Updates is checked.
2. Like George wrote, make sure the underlying table is not buffered.
3. Whenever I have trouble like this in a form, I try to duplicate the problem from the Command Window. In other words, go to the Command Window, open the view, make a change, then try to update it.
>When I issue a Tableupdate() on a view, it doesn't update the source table.
>
>The user makes changes to the view via the interface and clicks a Save button the sole command is Tableupdate(), however this is not updating the source table and when the user comes back later the old information is there.
>
>I also have an Undo button that has a Tablerevert() and that seems to work ok.
>
>Is there anything else I might be doing wrong or just plain missing?
>
>Thanks for the help in advance!
Chris McCandless
Red Sky Software