Question about Requery




Hello,
I'm using Delphi/ADO/MS-Access and there's a thing I can't solve.
My app has a MainTable with fields joined to secondary tables fields. When I call Requery method from a secondary table event handler (AfterPost) I need to call MainTable.Requery from there so that the changes appear in MainTable too.
The problem is that Requery method changes the grid cursor to another record and I need to avoid that. In other words, the grid cursor can't move to another record in my app after calling Requery, or it needs to return to the record it pointed before.
I tried to use Bookmarks but it didn't work.
Does anyone know how to solve this problem?
Thanks.
.