>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.
Elgin,
ActiveRow would typically be same as recno() and using recno() is better IMHO. However since this is a view neither recno() nor activerow might point to previous record after an update. If possible use an identifier key (I use a key for childs too though they wouldn't have any child).
For Activecolumn using controlsource (hence the fieldname) sounds better.
I don't recommend ActiveColumn and ActiveRow properties because they slow down grid operations.
Cetin