>Sorry but I didn't exactly explain my problem. What I have is a form that has a tabless pageframe. I am using a private data session. On one page I query the view then on the next page I have a grid which I allow the user to edit - its recordsource is the view. After they have edit I update and send the updates back to the table. After that they can go back to page one. The problem happens when I then try to go back to page 2 - same code for querying the view but this time it has the old data not what I have just updated to the tables.
THere is no reason to requery the data from page 1 to page 2. They both use the same view.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer