Results 1 to 7 of 7
  1. #1
    Bentley is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    50

    Records Opening in Forms


    I am having difficulty finding the setting that controls the order of the records when opening a form. I want the primary key that is reference to be in sequential order when cycling thru the records in the form. Right now, it opens number 5, then when I go to next, it goes 8, 1, 4, 2..... Not sure what I did to mess the order....

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    If you open the Form, go to Properties, and go to the Data tab, their is an "Order By" property where you can designate which field to sort your records by.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You can base the form on a query that provides the desired sorting:

    SELECT * FROM TableName ORDER BY FieldName
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Darn slow fingers!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Bentley is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    50
    Awesome. Thanks for the help and it's fixed. Now I just need to learn how to close out these threads... LOL..

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Joe was happy to help, I was happy to jump in late by accident.

    You can mark it solved using "Thread Tools" at the top of the thread.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Joe was happy to help, I was happy to jump in late by accident.
    Our answers are actually different ways of doing it, so I think they are both valuable!
    I actually almost exclusively do it your way, since I always base my Forms on Queries. But I realize that not everyone does this, and some base them directly on the Tables, which is why I offered up that suggestion.
    Of course, some of the advantages to using a query is you can do most of your calculations there, and it makes it really easy to change what is shown (simply by updating the underlying query).

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

Similar Threads

  1. Opening Forms Via Criteria
    By jlgray0127 in forum Forms
    Replies: 4
    Last Post: 03-31-2015, 07:26 PM
  2. Opening Forms Maximized
    By data808 in forum Forms
    Replies: 3
    Last Post: 04-29-2014, 04:37 PM
  3. Replies: 3
    Last Post: 10-23-2013, 08:11 AM
  4. Replies: 17
    Last Post: 11-24-2011, 03:37 AM
  5. opening forms extra records
    By Lupson2011 in forum Access
    Replies: 2
    Last Post: 08-31-2011, 10:26 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