Access 2003 form issue

G Gano · 05-19-2009, 02:41 PM

On my form I have created a Combo Box that is based on a small table. The source table has only one column (Field 1) that lists 73 different items that are sorted alphabetically. However, when I select the combo box on the form and the drop down menu appears that lists the 73 items, the items are not listed in alpha order, but listed randomly instead.

How can I make the drop down list sort the items alphabetically, as the underlaying table does?

GG
Houston, TX

**Dragoen** · 05-20-2009, 01:02 AM

Hi G,

On the Row Source property for the the combo box put in a query like:

Select [Field 1] from [table name] order by [field 1]

of course use your names for the field and table. The "order by " clause defaults to ascending or you can add desc for descending if you want the order reversed.

...order by [field 1] desc

hope that helps

G Gano · 05-23-2009, 07:03 PM

Sorry for the late response to your solution to my form question. It worked perfectly. I really appreciate the assistance.

Gary

05-19-2009, 02:41 PM	#1 (permalink)
G Gano Registered User Join Date: May 2009 Location: Houston, Texas Posts: 6 OS: xp	Access 2003 form issue On my form I have created a Combo Box that is based on a small table. The source table has only one column (Field 1) that lists 73 different items that are sorted alphabetically. However, when I select the combo box on the form and the drop down menu appears that lists the 73 items, the items are not listed in alpha order, but listed randomly instead. How can I make the drop down list sort the items alphabetically, as the underlaying table does? GG Houston, TX

05-20-2009, 01:02 AM	#2 (permalink)
Dragoen TSF Enthusiast Join Date: Apr 2009 Location: Harrisburg, PA Posts: 1,024 OS: Windows Vista Home Premium (6.0, Build 6001) My System	Re: Access 2003 form issue Hi G, On the Row Source property for the the combo box put in a query like: Select [Field 1] from [table name] order by [field 1] of course use your names for the field and table. The "order by " clause defaults to ascending or you can add desc for descending if you want the order reversed. ...order by [field 1] desc hope that helps __________________ Dragoen ========================================================= Just because we can, doesn't mean we should...

05-23-2009, 07:03 PM	#3 (permalink)
G Gano Registered User Join Date: May 2009 Location: Houston, Texas Posts: 6 OS: xp	Re: Access 2003 form issue Sorry for the late response to your solution to my form question. It worked perfectly. I really appreciate the assistance. Gary