 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / July 2007Order of records on the form
Hi For some reason when I add a new record it is not the last record on the form What is the cause of it and what in fact sets the order of the records Thank you, Samuel Dear Samuel: The form can be based on a table or a query. Think of the records in a table as a "bag of records" - unordered. If you want to place an order on the records in a table, create a query - then base the form on the query. HTH!  SignatureFred Boer - Amateur Access Enthusiast Interests: Library software / Z39.50 / Web Services Freeware Small Library Applications available here: http://www3.sympatico.ca/lornarourke/ > Hi > [quoted text clipped - 5 lines] > Thank you, > Samuel The strange thing is that it never been like that before? Is it possible that it is due to importing the table from another database? > Dear Samuel: > [quoted text clipped - 12 lines] >> Thank you, >> Samuel Dear Samuel: Possibly. In any case, you can't trust a table to have a specific sort order - create a query and use it to assign an order. You'll be happy you did! <g> SignatureFred Boer - Amateur Access Enthusiast Interests: Library software / Z39.50 / Web Services Freeware Small Library Application available here: http://www3.sympatico.ca/lornarourke/ > The strange thing is that it never been like that before? > [quoted text clipped - 17 lines] >>> Thank you, >>> Samuel You may have clicked in a form field and sorted on it. Access saves this information when the form is closed. Open the form in design view and remove any order by or filter that you don't want. As has already been mentioned by Fred, you need to control the sort order yourself by using a query with an order by clause. If you want to order records by their entry order, you need to use an autonumber as the primary key for the table and sort on that. > The strange thing is that it never been like that before? > [quoted text clipped - 17 lines] >>> Thank you, >>> Samuel |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.