Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Scroll bars (Access XP WinXPPro)

    I have a continous form I am using in place of a subform. I want the continous form to open and move to the last record in the list.
    The line DoCmd.GoToRecord, ,acLast works great except the screen scrolls all the way up hiding all previously entered records and only displays the last entered record. Is there any way to get it to move to the last record and still display the previous 5-10 entries.
    Thank you for any suggestions

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Scroll bars (Access XP WinXPPro)

    Try this, and adjust the - 5 as needed:

    Private Sub Form_Load()
    Me.SelTop = Me.Recordset.RecordCount - 5
    DoCmd.GoToRecord , , acLast
    End Sub

  3. #3
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Scroll bars (Access XP WinXPPro)

    Hans,

    As always worked perfect.

    Thank you,
    Carla

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •