Results 1 to 3 of 3
  1. #1
    Euler271 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2017
    Posts
    63

    Scrolling records on non-continuous form

    Many years ago I found some code that allowed the user to scroll through records on a non-continuous form. In other words, let's say there are three fields in the recordset. Let's also say that there are three rows of three text boxes (or labels) on the form. On opening the form, all nine controls are filled with the first three records in the table. Pressing an up-arrow button causes the record in the first row to disappear, the second record to move to the first row, the record in the third row to move to the second row and a fourth record (if one exists) to occupy the third row of controls. Pressing a down-arrow button causes the opposite to happen: The record in the first row moves to the second row, the record in the second row moves to the third and nothing appears in the first row. The arrow buttons gray out if the beginning or end of the recordset is reached.

    I can't remember why this method was superior to using a continuous form but it was. Unfortunately, I no longer have the code so that's why I'm asking the community if anyone has code that can do this.



    Thanks for your help.

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    See if this navigation button material from Martin Green addresses the concept (at least partially).
    He includes a sample database. I'm sure you can adapt it as necessary.
    Good luck.

  3. #3
    Euler271 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2017
    Posts
    63
    Quote Originally Posted by orange View Post
    See if this navigation button material from Martin Green addresses the concept (at least partially).
    He includes a sample database. I'm sure you can adapt it as necessary.
    Good luck.
    Yes, that does help a little. Thanks for replying.

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

Similar Threads

  1. continuous form vertical scrolling
    By BalloonPlanning in forum Forms
    Replies: 24
    Last Post: 02-20-2018, 02:39 PM
  2. Replies: 4
    Last Post: 08-29-2016, 06:36 AM
  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