Return to a Specific Record

[LarryP]

Form A has a doubleclick event attached to one of its fields. That event
opens form B, which displays a list of possible values. Doubleclicking one
of the values generates an SQL update of the table underlying Form A,
followed by a requery of form A. After that I want to close Form B and go
back to the specific row in Form A (it's in datasheet view) where the first
doubleclick happened. At the moment, presumably because of the requery, it
returns with the first record active, NOT the one I doubleclicked.

What's the easiest way to do this? I tried to figure something out using
bookmarks, but the requery resets all bookmarks, so that got me nowhere.
Help, please.

 

[Jeanette Cunningham]

Larry,
there is a small utility written by Stephan Lebans that you can use to
return to the same row - it's called RowNumber.

a.. RowNumber
a.. DownloadFiles/rownumber.zip
below is the website
http://www.lebans.com/toc.htm

Jeanette Cunningham

 

[LarryP]

Cool site. Many thanks.

Larry,
there is a small utility written by Stephan Lebans that you can use to
return to the same row - it's called RowNumber.

a.. RowNumber
a.. DownloadFiles/rownumber.zip
below is the website
http://www.lebans.com/toc.htm

Jeanette Cunningham