>I have a grid on a form that displays child recs based on a view from 3 table join to include lookup info. When I add a new child records during data entry, my lookups that are part of the view is not displayed in the grid, only those columns that are based on the actual child table. When I try to requery the view, it shows an error that says I haven't updated the view's buffering. I only want to update the tables/view when the user clicks the save button but is this not possible?
>
>TIA
>John.
John, you can't requery() a view that has been changed unless you do a TableUpdate() or TableRevert(). If you've added a new record, your view has been changed, so you will have to do one or the other.
HTH
Barbara