Drop down box in alphabetical order (1 Viewer)

[lovelylauralin]

I have created a form with a drop down box so that I can click on a client in the drop down box and it will pull the information from that clients record.. my question is :
Is there a way of having the clients names in the drop down box listed in alphabetical order without it changing the order in my table? My table is listed in order of project numbers not client names.

 

[pbaldy]

Your source should be an SQL string rather than the table itself, where you can include an ORDER BY clause:

SELECT ClientName
FROM TableName
ORDER BY ClientName

 

[lovelylauralin]

I am new at Access and I am unsure of what an SQL string is.. I am going to go and try to look it up.. if you have any more information I would greatly appreciate it.
Thanks!

 

[pbaldy]

It's a query. If you look at the properties of your combo, I assume in the row source it shows the table name. To the right of that (when you click in that row) are elipsis (...). Click on that and say yes when it asks if you want to build a query. It should put you in the query builder with the table already in the top section. In the "Field" row select the appropriate field, and in the "Sort" row select the appropriate order. Close it all out and you're done. The Row source will now say something similar to what I posted earlier.

 

[hhzyousafi]

Hi pbaldy,

I tried what you said and unfortunately my Combo Box is showing up empty. Can you please help me

Regards,

Zohair

 

[jdraw]

hhzyousafi,
Here's a link that may help you with combo boxes
http://www.techonthenet.com/access/comboboxes/

lovelylauralin,
For info and examples of SQL and vba
see
http://www.fontstuff.com/access/acctut14.htm

 

[hhzyousafi]

Thank you jdraw! That helped.