Results 1 to 15 of 15
  1. #1
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317

    Continuous subforms scrolling/painting issue

    The attached database contains an unbound form with two identical subforms in continuous forms view. For some reason, the subform on the right scrolls properly using the down button on the scrollbar, but the one on the left repaints only the top ten rows, giving the effect of freezing all the rows from the eleventh onwards (I've highlighted the cut-off point in the screenshot below). The only difference between the two subforms is their positions. Does anyone know the cause and/or the solution?



    Click image for larger version. 

Name:	Illustration.png 
Views:	21 
Size:	61.2 KB 
ID:	45019
    Attached Files Attached Files

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    works for me, but then the code in your posted db has been commented out.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Can't replicate. Both sides scroll down, down, down OK for me.
    Down arrow at bottom of vertical scroll bar
    Inside vertical scroll bar
    PGDN key on KBD

    All work fine as expected.

  4. #4
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    Quote Originally Posted by Micron View Post
    works for me ...
    How many rows can you see at a time?

    Quote Originally Posted by Micron View Post
    ... but then the code in your posted db has been commented out.
    Not sure what you mean. There are no VBA modules.

    Edit: Aargh! Sorry, the modules are something I'd been playing with. I'd meant to delete them.

  5. #5
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    Quote Originally Posted by davegri View Post
    Can't replicate. Both sides scroll down, down, down OK for me.
    Down arrow at bottom of vertical scroll bar
    That's precisely where the problem occurs for me. Pulling the thumb/tab/slider doesn't cause any problems.

    How many rows can you see at a time?

  6. #6
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Quote Originally Posted by Remster View Post
    That's precisely where the problem occurs for me. Pulling the thumb/tab/slider doesn't cause any problems.

    How many rows can you see at a time?
    16 rows visible.

  7. #7
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    Quote Originally Posted by davegri View Post
    16 rows visible.
    So just to be clear, when you open the main form and click on the down arrow on the vertical scrollbar in the first subform, all the visible records in that subform move up a place?

    I'm wondering if it's a version issue. I note that both you and Micron have 2016, which is what I had until recently.

  8. #8
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Quote Originally Posted by Remster View Post
    So just to be clear, when you open the main form and click on the down arrow on the vertical scrollbar in the first subform, all the visible records in that subform move up a place?

    I'm wondering if it's a version issue. I note that both you and Micron have 2016, which is what I had until recently.
    Exactly, for as many times as I click.

    Actually I have Access 2019, but the website only has options to show up to 2016.
    It could be a version issue, as O365 has updates not available for the standalone versions.

  9. #9
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I see 19 because I had to resize everything. With the ribbon visible I couldn't even see the scroll buttons. Clicking/dragging seems normal. Bar click moves a page of records. I turned off Access updates long ago (365).
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  10. #10
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    I have Office 365 and both subforms display 700 records
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  11. #11
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    Quote Originally Posted by davegri View Post
    It could be a version issue, as O365 has updates not available for the standalone versions.
    Thank you.

  12. #12
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    Quote Originally Posted by Micron View Post
    I see 19 because I had to resize everything. With the ribbon visible I couldn't even see the scroll buttons.
    That's useful to know. I've amended my master copy accordingly.

  13. #13
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    Quote Originally Posted by mike60smart View Post
    I have Office 365 and both subforms display 700 records
    Not all at once, presumably! I can access all the records. The problem is that the bottom five don't change - see the image in my original post. After Brian Elesson, you should see Royce Elicea on both sides. But on the left, you see Rick Backson, who was in the eleventh row when the form was first loaded.

  14. #14
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    I made my forms easier to navigate by sorting by the Player Control.

    When I scroll through the records in the subforms I find that both subforms can be made to match
    Attached Thumbnails Attached Thumbnails Level.JPG  
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  15. #15
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    Thanks, folks. I've now posted something in the Code Repository section, which shows where this was leading.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Scrolling records on non-continuous form
    By Euler271 in forum Programming
    Replies: 2
    Last Post: 04-11-2018, 09:08 AM
  2. continuous form vertical scrolling
    By BalloonPlanning in forum Forms
    Replies: 24
    Last Post: 02-20-2018, 02:39 PM
  3. Replies: 2
    Last Post: 08-03-2016, 11:29 AM
  4. Replies: 2
    Last Post: 04-22-2014, 02:48 PM
  5. Stop Continuous Form Scrolling up
    By Deutz in forum Forms
    Replies: 4
    Last Post: 10-19-2011, 10:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums