468,275 Members | 1,821 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,275 developers. It's quick & easy.

Recalc or refresh - focus current record in subform lost

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
1 6623
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.

Similar topics

reply views Thread by P Mitchell | last post: by
1 post views Thread by New2Access | last post: by
5 posts views Thread by Andrew Chanter | last post: by
17 posts views Thread by Neil Ginsberg | last post: by
6 posts views Thread by Bernie Hunt | last post: by
reply views Thread by zattat | last post: by
1 post views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.