Results 1 to 4 of 4
  1. #1
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591

    Continuous Form Ordering Alphabetically

    I have a continuous form, in a subform, with four fields in it. The first is an alpha-numeric code always starting with a letter. The second is a description field. The third and forth are date fields. I just noticed that after data entry the form sorted by the alpha numeric code which is totally incorrect. It should sort by data entry order. In most cases that would be the first date field, but not necessarily. I created this form some time back, but never noticed this until now. I may have done something to alter the sort, but I'm not sure. How do I get this back to sorting in data entry order. I'd rather not change the structure of the table by adding an autonumber field, but I could, necessary.

    Thanks in advance.



    Paul

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    If your data does not have a field which explicitly specifies the data entry date/time, you cannot sort on it. Access does not have a "record order" sort, i.e. you can only sort on data which is actually in the table (or query).

    To get your form to sort the way you want, you can create a query which uses the correct sort order, and then use the query as the form's record source.

    But you are still going to have to create a new field in your table.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    How do I get this back to sorting in data entry order
    As join says you need a timestamp field - date datatype and the default=now(). Then sort on that field

  4. #4
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591
    OK, great. Thanks for your suggestions.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. ordering by date in a form
    By migaccess in forum Access
    Replies: 5
    Last Post: 12-10-2014, 07:19 PM
  2. Simple ordering form
    By jammerculture in forum Access
    Replies: 27
    Last Post: 11-15-2012, 10:42 PM
  3. Replies: 3
    Last Post: 12-02-2011, 07:59 PM
  4. Ordering Data within a form
    By system243trd in forum Forms
    Replies: 1
    Last Post: 12-02-2011, 12:36 PM
  5. Replies: 5
    Last Post: 06-30-2009, 09:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums