Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Continuous Form Question (97/SR2)

    Hi all,

    I have a continuous form sorted descending by date, is there any way of getting the new record box to appear at the top of the list instead of at the bottom?
    Any help will be much appreciated.

    Thanks.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Continuous Form Question (97/SR2)

    The only way I see, would be to add the new record with the sorting criteria by code, and requery the form.
    Francois

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

    Re: Continuous Form Question (97/SR2)

    Even is a form sorted in descending order, the pending new record is always at the bottom. It hasn't been saved yet, so it can't be sorted.

    If you want to enter a new record at the top, put a series of unbound controls in the form header so that they look like one of the continuous records. Allow the user to enter data into the unbound controls and then when they either click a Save button or tab out of the last control, use code to write the data into the fields of a new record, save it, and clear your unbound controls for the next "new record".
    Charlotte

  4. #4
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Continuous Form Question (97/SR2)

    Thanks for your replies. I had a feeling it wouldn't be a simple option somewhere. I could remember seeing it in an old database, but didn't get a chance to look at the design, and the database has been archived off somewhere (oblivion probably!). Thanks for your help, i'll now go and put it into practice!

Posting Permissions

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