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.