 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 2005sorting data on a form
I have a simple form with seven fields, based directly on a simple table with seven fields. When the form is opened, I'd like the records displayed in alpha order on the field [LastName]. I've typed "LastName" and "[LastName]" (without quotes) in the order by property, but it doesn't do anything. What am I missing here? Jerry Why not set the order in the form's record source query?  SignatureDuane Hookom MS Access MVP >I have a simple form with seven fields, based directly on a simple table >with seven fields. When the form is opened, I'd like the records displayed [quoted text clipped - 5 lines] > > Jerry Easily done, I guess. Currently I have the source as the table, since I'm using all 7 fields. Is it more efficient to use a query as the record source rather than a table in that situation? Jerry A query should not slow your form loading. SignatureDuane Hookom MS Access MVP > Easily done, I guess. Currently I have the source as the table, since I'm > using all 7 fields. Is it more efficient to use a query as the record > source rather than a table in that situation? > > Jerry Also, if you don't want a stored query that users can modify, you can set the source of the form to the select statement directly, such as SELECT * FROM yourTable ORDER BY LastName > Why not set the order in the form's record source query? > [quoted text clipped - 7 lines] >> >> Jerry |
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
|
©2008 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.