Drop Down List

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

How do I put the contents of a drop down list in alphabetical order? I've
tried sorting the source column in the table where the information resides
with no help. I'm having trouble locating the information in the Help
section. Any help would be appreciated. Thx.
 
Steve,
Are you using a named table as the RowSource?
Try using a query as the RowSource for your combobox. Bring in the
table/fields you want to work with into the query, and do your sorting
there.
That should do it...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
How do I put the contents of a drop down list in alphabetical order?  I've
tried sorting the source column in the table where the information resides
with no help.  I'm having trouble locating the information in the Help
section.  Any help would be appreciated.  Thx.
Click to expand...

If you use the control wizard which will automatically come up if you
have it selected in the controls group when you add a combo box to a
form, then it will ask you what field you want to sort by and you can
sort the contents of your combo box that way.
 
Back
Top