Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Aug 2002
    Location
    Wichita, Kansas, USA
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding new records (2000)

    I have a subform displaying most recent records first. I have had a request from the group using this dbase asking if we can have the new blank record in the subform be at the top of the list instead of at the bottom where it automatically lets you enter new records. Is there any way to do this?

    Thanks! Patty

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

    Re: Adding new records (2000)

    In one word: no. The blank new record is always at the end, whatever the sort order of the form.

  3. #3
    Star Lounger
    Join Date
    Aug 2002
    Location
    Wichita, Kansas, USA
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding new records (2000)

    That is what I thought. Thanks for the confirmation.

    Patty

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Adding new records (2000)

    Hans is correct - no way to do it with the built-in subform. There are however some workarounds. One we use occasionally is to use a set of unbound controls and actually add the record using VBA. Another approach is to use a pop-up form to add a record and then requery the subform data source.
    Wendell

Posting Permissions

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