Aphabetical Order

[louisa]

This is probably a really easy question (i Hope) i have combo box on my main form which lists all company names so when selected will take you to the relevant record. Is there anyway i can set the combo box to list all the companys alphabetically?

Thank you

 

[DCrake]

Assumably your rowsource is bound to an underlying query. Edit the query and sort ascending on the company name.

Example:
Select CompanyID, CompanyName from TblCompanies Order CompanyName;

David

 

[louisa]

This is my row source

SELECT Contacts.ContactID, Contacts.CompanyName FROM Contacts;

Where abouts do i change in order for it to be alphabetical??

Thanks for your help.

 

[DCrake]

If you actuall looked at my example you would have noticed the place where to include the sort order

SELECT Contacts.ContactID, Contacts.CompanyName FROM Contacts ORDER BY CompanyName;

David

 

[louisa]

Thank you for your help.