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.
Mark McCasland
Midlothian, TX USA