I have 7 grids on 7 pages of a pageframe on a form to display the Parent and 6 child Views of the Main form. I have added a textbox class to each column on each grid for doubleclicking the grid/cell and have an event or procedure fire. I use it to launch my "zoom in" form to zoom in on the currently selected record.
While on the "Zoom In" form your able to navigate through the records of the child table. When I close the form and return to the grid I notice the grid doesn't update unless I issue a Requery command, however that causes the record pointer in the child view to move to the top of the currently selected records.
I want the Grid to keep track of where I'm navigating in the "Zoom In" form and be on that record when I return.
In the main form's data environment I have just the Parent View. This is because most of the time the user may only open 1 or 2 of the child views and I didn't want to have all 6 child views opening everytime. So on the Activate method of each page I call a custom method "GetView" to open the needed view and Requery to refresh the grid(s).
Do I want to use the ActiveColumn and ActiveRow properties to track my location in the Grid?
Thanks ahead of time.