[AccessD] New Record Appearing on Top

Julie,

    It so happens that the point raised by Charlotte has already been taken care of in my sample db (AddDataAtTop) mentioned in my earlier post dated 16-Aug-2005.

    For the ongoing session, recently added records are highlighted suitably and continue to be in view at the top. As and when a new session is taken up (on re-opening the switchboard form), all existing records get re-positioned in prescribed sort order.

Best wishes,
A.D.Tejpal
--------------

  ----- Original Message ----- 
  From: Julie Reardon-Taylor 
  To: accessd at databaseadvisors.com 
  Sent: Tuesday, August 16, 2005 22:01
  Subject: RE: [AccessD] New Record Appearing on Top


  Good point Charlotte.  I don't really like it either.....and certainly have given the client what they want, only to have to turn around and "re-do" what they thought was a great thing.  Thank you for your thoughts.

  Julie Reardon-Taylor
  PRO-SOFT OF NY, INC.
  44 Public Square Suite #5
  Watertown, NY 13601
  Phone/Fax: (315) 785-0319
  www.pro-soft.net

    ----- Original Message ----- 
    From: Charlotte Foust 
    To: Access Developers discussion and problem solving 
    Sent: Tuesday, August 16, 2005 21:09
    Subject: RE: [AccessD] New Record Appearing on Top


    Others have given you chapter and verse on approaches to this, so let me ask you a question:  Is the client going to be happy with the new rows falling to the bottom of the list after they're added "at the top"?
    Depending on the default sort for the form/subform, that row just added at the top may disappear entirely from the visible records.  That is something clients frequently overlook when asking for a feature like this, and it needs to be discussed before you go to a lot of effort to provide something they're going to decide they don't like.  

    Charlotte Foust