{"id":452,"date":"2018-08-04T12:55:45","date_gmt":"2018-08-04T16:55:45","guid":{"rendered":"https:\/\/access-diva.com\/blog\/?p=452"},"modified":"2018-07-31T13:59:00","modified_gmt":"2018-07-31T17:59:00","slug":"maintain-scroll-position","status":"publish","type":"post","link":"https:\/\/access-diva.com\/blog\/?p=452","title":{"rendered":"Maintain Record Position After Update"},"content":{"rendered":"

When updating a record on a Continuous Form it has a tendency to scroll back up to the top.\u00a0 For End Users this can be problematic as they have now lost their place and have to scroll down to find it.\u00a0 Here’s two slightly different Function to prevent that…<\/p>\n

This one will<\/strong> cause the record<\/strong> to float to the top of the Form but the scrollbar<\/strong> maintains its position…<\/p>\n

\r\nFunction fRequeryPlus(frm As Form)\r\n'To use fRequeryPlus Me\r\n    Dim intRecordID As Integer\r\n\r\n    intRecordID = frm.CurrentRecord\r\n    frm.Requery\r\n    DoCmd.GoToRecord , , acGoTo, intRecordID\r\n\r\nEnd Function\r\n<\/pre>\n
 <\/p>\n
This one will keep record<\/strong> and scrollbar position<\/strong> intact…<\/p>\n
\r\nFunction fRefreshPlus(frm As Form)\r\n'To use fRefreshPlus Me\r\n    Dim intRecordID As Integer\r\n\r\n    intRecordID = frm.CurrentRecord\r\n    frm.Refresh\r\n    DoCmd.GoToRecord , , acGoTo, intRecordID\r\n\r\nEnd Function\r\n<\/pre>\n
Note<\/strong><\/span>, if you are deleting a record then only fRequeryPlus()<\/strong> will work UNLESS you only mark the record<\/strong> for deletion and delete upon closing<\/strong> the Form, in that case you can use fRefreshPlus()<\/strong>. Other than that you will see #DELETED<\/strong> in the controls for that record.<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
When updating a record on a Continuous Form it has a tendency to scroll back up to the top. For End Users this can be problematic as they have now lost their place and have to scroll down to find it. Here’s two slightly different Function to prevent that…<\/p>\n
This one will cause the record […]<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,63],"tags":[94,20,22],"class_list":["post-452","post","type-post","status-publish","format-standard","hentry","category-access-tips","category-form-design","tag-continuous-form","tag-forms","tag-subforms","odd"],"_links":{"self":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=452"}],"version-history":[{"count":6,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/452\/revisions"}],"predecessor-version":[{"id":455,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/452\/revisions\/455"}],"wp:attachment":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}