>Something I never really thought about until it happened to me. I have a local view [view 1] that is based on a table and another local view [view 2]. I used this new view as the record source of a grid. When I went to issue a requery and a refresh because of a data change, the data in the grid did not change. Because View 1 opens the table and view 2, the requery of view 1 did not automatically cascade the requery down to view 2.
>
>When I realized this, it did make sense because view 2 was already open as a data source for view 1. The solution was to requery view 2 first then view 1.
>
>I submit this only for future reference and searches for others that may benefit from this.

Keep in mind that if this view is updateable, TABLEUPDATES() have to be done this way also.