Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Edinburgh, Midlothian, Scotland
    Thanked 0 Times in 0 Posts

    Continuous Form (Access 2000)

    I have a continuous form which I open via a vba module.

    As it is now a fairly long form, I have used

    DoCmd.GoToRecord , , acLast

    with the OnCurrent event to move to the end.

    This works to an extent, as it shows me only the last record, at the top of the screen. Is there a way to make it show me a screen-full with the last record at the bottom of the screen?


  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 33 Times in 33 Posts

    Re: Continuous Form (Access 2000)

    Yes, but it involves some code. You need to use the AbsolutePosition property of the recordset. Move to last record, get the REcordCount, the subtract a value related to how many records you want to display. For example, if your window displayes 10 records, I'd subtract 8 from the record count. This allows for 8 records + the NewRecord.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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