>>>I have a pageframe with 2 pages. Each page has a grid. Both of them draw the contents from the same table. The only difference between them is that one will grap all the record with status=1 and the other grap the record with status=0. I created 2 views for each of the grid. On the form, users are allowed to change the status. My problem is everytime I change the status from 1 to 0 (or vice versa), say from page 1, and go to the page 2, the grid on page 2 will not show the updated record. However, if I browse back to page 1, the grid got updated, so is page 2. Does anyone out there know how I can get the grid shown the updated information the first time I switch pages? Thanks in advance!
>>>
>>>Chu
>>
>>In the page.activate event, put
>>requery('myview')
>>this.refresh
>
>I have the above code, but it doesn't work. I also try the following code in the page.deactivate.event.
>
>LOCAL cRecordSource
>WITH this.parent.otherpage.otherGrid
>cRecordSource=.cRecordSource
>.RecrodSource=cRecordSource
>ENDWITH
>requery('myview')
>this.refresh
>this.parent.otherpage.otherGrid.refresh
>
>Again, it also doesn't work. Any suggestion?
>
>Chu

Do you tableupdate() before leaving one page, so the underlying table is aware of the changes.