Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Omaha, Nebraska
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    New (Blank) Record at Top of list? (Access 2000)

    I have a user that would like the 'new' record to be placed at the top. By default, the blank record where users type in their new record is on the bottom of the list screen, is there a way to make it appear at the top of the list?

    (I'm not sure why they are insisting on doing this, but they are. IMHO they could just scroll to the last record, or click the 'Add Record' button that Access provides in the navigation bar...)

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

    Re: New (Blank) Record at Top of list? (Access 2000)

    No. You can make a form open at a new record, if you like, but the new record will always be the last.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: New (Blank) Record at Top of list? (Access 2000)

    The only way you can "do" this is to fake it, using unbound controls in the form header and then writing the values to a new record. The newly created record is still going to be at the bottom of the list once it's created, however, because there is no inherent meaningful position in Access records.
    Charlotte

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New (Blank) Record at Top of list? (Access 2000)

    Give this a try

    http://www.rogersaccesslibrary.com/OtherLi....asp#Tejpal,A.D.

    Look at AddDataAtTop.mdb

    HTH

    John

Posting Permissions

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