When I requery or recalc my parent form after I updated a record in my subform, I lose the focus of that particular record in my subform. Instead, the first record is selected.

How can I avoid this?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bookmark the current record. After the requery/recalc set the subform's
Bookmark back to the old Bookmark. Of course, if the ordering of the
recordset changes during the requery/recalc the Bookmark may not work.
Then try saving the Primary Key & after the requery/recalc try a Seek to
find the record.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)