Results 1 to 4 of 4

Scroll New Record to the bottom of a subform

  1. #1
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    503

    Scroll New Record to the bottom of a subform

    This is related to the same project I previously posted about. Everything functions well, but I would like a small cosmetic change. This all takes place in a subform. The On Load event triggers
    Code:
        DoCmd.GoToRecord , , acNewRec
    . This works fine, but it only shows a single blank record at the top of the subform with all the previous rows hidden above. I would prefer to have the new record appear at the bottom of the subform with the previous records that fit displaying above it. These two pics should make it clear.

    Click image for larger version. 

Name:	scroll up.JPG 
Views:	17 
Size:	35.2 KB 
ID:	27414
    Default View

    Click image for larger version. 

Name:	scroll down.JPG 
Views:	17 
Size:	110.1 KB 
ID:	27415


    Desired view.

    This is a minor matter. If there is simple solution. I'll take it. If not, I'll let it slide.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,754
    That is the default way,for them to be on top.
    just click the new record button (asterisk icon) at the bottom record counter/tool.

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,240
    Kind of wonky but maybe manually add some rows (create an Add Record button but add these extra Goto):

    DoCmd.GoToRecord , "", acNewRec
    DoCmd.GoToRecord , "", acPrevious
    DoCmd.GoToRecord , "", acPrevious
    DoCmd.GoToRecord , "", acPrevious
    DoCmd.GoToRecord , "", acPrevious
    DoCmd.GoToRecord , "", acNewRec
    Me.YourFirstFieldInRow.SetFocus

    Another idea is to include unbound fields in the footer with an Add button and when they put in the new record values, use button to write them to table, then Requery the form and blank out those unbound fields.

  4. #4
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    503
    Gonna leave it just the way it is. The changes were just cosmetic. The form finally functions as intended and is out for testing right now. I'll only make changes as required by my testers.

    Thanks for your suggestions.

    Paul

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

Similar Threads

  1. Replies: 2
    Last Post: 09-10-2015, 03:21 PM
  2. Replies: 4
    Last Post: 04-17-2014, 07:14 AM
  3. Scroll Wheel Hides(?) Record in Subform
    By Degs29 in forum Access
    Replies: 1
    Last Post: 06-26-2013, 03:36 PM
  4. Scroll Bar position with a subform
    By pelicanbuyer in forum Forms
    Replies: 2
    Last Post: 05-22-2013, 02:46 PM
  5. Replies: 1
    Last Post: 08-06-2010, 07:50 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
  •  
Tech Forums: Microsoft Office Forums