By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,109 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Recalc or refresh - focus current record in subform lost

P: n/a
Main Form/SubForm

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?

--
Reginald Bal
Feb 24 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Reginald Bal wrote:
Main Form/SubForm

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)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQ/9hroechKqOuFEgEQJvjgCeMst5v7r+IBjhB8kDQzJNT9eebJEA oNes
eUNiTb7cPNLcy9Jd9PCAmbD8
=iYTl
-----END PGP SIGNATURE-----
Feb 24 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.