>I have a grid with a view as the recordsource. The view is filtered in the data environment on an id from a "parent" table. I navigate the "parent" table and the grid refreshes with the correct "child" records but the grid scrolls up and displays the last record as the activerow. I have tried using activatecell(1,1) in the page.refresh and grid.refresh methods but then I cannot navigate the grid (keep getting pushed to the top). Is there any property that I am overlooking or a one shot method to display the top row in a grid?
Basically, if you want to show the first row, you may say
Select Mycursor && this is recordsource
Go Top
Thisform.Grid.Setfocus
Generally, it's not the best idea to use filter in grid.
Edward Pikman
Independent Consultant