Just use the ORDER BY clause in the SQL statement that you use to select data to populate your form.
e.g. SELECT LastName, FirstName, Address, City, State, Zip FROM MyTable ORDER BY LastName _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of wheeliegirl Sent: Monday, July 25, 2005 5:40 PM To: [email protected] Subject: [vbhelp] NEED HELP Sorting a LARGE table! Hi Everyone: I am doing my workterm for an IT Diploma. This is my first time out in the field as a programmer. I am creating a program for an orgnaization using VB6 and MS Access 2000. There are many tables and forms in the program that I am creating. one of the tables has over 300 records in it. Wht is the best way for me to ensure that the records are sorted when I open the VB GUI and Display the records. In one of my VB6 forms I want to sort the data according to last name and in another form I want to sort the data by ID Number. I have a Project Module in VB as well if that will help answer my question. Tahnk you for any help anyone can give me. '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [email protected] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= _____ YAHOO! GROUPS LINKS * Visit your group "vbhelp <http://groups.yahoo.com/group/vbhelp> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service. _____ [Non-text portions of this message have been removed] '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [email protected] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
