Update combo box

[Jamie]

I have a combo box in a form which takes its data from a table with just
company names. when i update this table to add more companies they will show
in the combo box but not in alphabetical order. how can i get the updated
table to show alphabetically in the combo box

 

[Al Campagna]

Jamie,
Instead of using a table as the RowSource for your combo, use a query,
and set the sort accordingly.
Company Ascending
--
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."

 

[Tom van Stiphout]

On Tue, 17 Mar 2009 06:04:06 -0700, Jamie

Create a new query, select the table, select the CompanyName field,
and set the Sort property.
Use this query as the RowSource for your combobox.

-Tom.
Microsoft Access MVP