Is there a way to ask a form what the first visible row is? I have controls on my form which cause some rows to disappear and reappear and I would like the row to end up in the same place after the user chooses to hide and then unhide some of the rows.
The best I can do is remember the current row before buttons are pressed, and then make that the first visible row after all the buttons are pressed, but that often causes the view of the data to jump around.
Basically I have a view of objects some of which are lots and some of which are wafers in lots. The user can hide the wafers and then unhide the wafers. If the user is currently pointing to the row that is fifth from the visible top, then after hiding and unhiding the wafers, I want the cursor on the same row and I want it to be fifth from the visible top.
Any ideas? I am using Access97, but may soon be upgrading my app to Access2000. So a solution that works in both or either would be acceptable.