Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

alphabetical order in combo list 1

Status
Not open for further replies.

skaurd

Technical User
Jun 4, 2002
51
GB
HI
How can I make my combo list appear with the list of records in alphabetical order?

thanks

S
 
Right click the combo box in design mode, click properties. Find the RecordSource Property and click the ellipse to the right of the box. Find the field you wish to sort and sort is ascending in the SQL Query window. Click the X to close the SQL Query window and select yes when prompted to update the source.

YOu are set....Let me know if you need anythign else. It's not important that someone else can do in one step what it took you ten to do...the important thing is that you found a solution. [spin]

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top