Need Help:Sorting Records on Form List Box

[RDMRDM]

I have an Access form that shows data from a table called "Contacts". This table has a list of contacts and their information. On the form, I added a "List Box" showing Lastname and Firstname from the contacts table. I added this to allow me to find various contacts in the table by selecting their name. However, the list is not sorting properly. I would like the records in the list box to sort alpha order by "LastName". How should I do this? Currently it's sorting by the ContactID field. I am using Access 03. Thanks in advance for any help.

 

[traingamer]

Just go into the 'RowSource' of the List Box and adjust it to sort by whatever you need. You can sort by both Lastname and firstname.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[RDMRDM]

Thanks for the info. My Row Source field currently reads as follows: SELECT Contacts.ContactID, Contacts.LastName, Contacts.FirstName FROM Contacts;


What would I update it to so it sorts alpha order by Lastname and Firstname? Thanks.

 

[Pampers]

You could add a sortorder to the query by hand:

SELECT Contacts.ContactID, Contacts.LastName, Contacts.FirstName FROM Contacts Order by LastName;

or open up the query builder at the rowsource (...) and add on order.

Pampers
Keeping it simple can be complicated

 

[TheAceMan1]

How are ya RDMRDM . . .

Copy/paste from below in its place . . .

[blue]SELECT ContactID, LastName, FirstName FROM Contacts ORDER BY LastName, FirstName;[/blue]

See Ya! . . . . . .

 

[RDMRDM]

Got it. Thanks for your help.

 

[TheAceMan1]

RDMRDM . . .

Great!

BTW: [blue]Welcome to Tek-Tips![/blue] To get great answers and know whats expected of you in the forums be sure to have a look at FAQ219-2884

See Ya! . . . . . .