By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,853 Members | 2,246 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,853 IT Pros & Developers. It's quick & easy.

Re-order a Combo Menu

P: n/a
I have a combo field in access 97, which you select customers from, but
if you add a new customer into the customer accounts it put them at the
bottom of the combo menu. Is there a way to make all new entries be
placed in order, so that when you look at the combo box it is already
in alphabetical order. I have gone into the table and put it in order,
but when you use the combo menu it is out of order again.

Aug 11 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Base the combo box rowsource on a query that sorts the records according to
your requirements.

--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited

Small Business Solutions Provider

"feeman" <fe*********@feehally128.karoo.co.ukwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
>I have a combo field in access 97, which you select customers from, but
if you add a new customer into the customer accounts it put them at the
bottom of the combo menu. Is there a way to make all new entries be
placed in order, so that when you look at the combo box it is already
in alphabetical order. I have gone into the table and put it in order,
but when you use the combo menu it is out of order again.

Aug 11 '06 #2

P: n/a

Craig Alexander Morrison wrote:
Base the combo box rowsource on a query that sorts the records according to
your requirements.

--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited

Small Business Solutions Provider

"feeman" <fe*********@feehally128.karoo.co.ukwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
I have a combo field in access 97, which you select customers from, but
if you add a new customer into the customer accounts it put them at the
bottom of the combo menu. Is there a way to make all new entries be
placed in order, so that when you look at the combo box it is already
in alphabetical order. I have gone into the table and put it in order,
but when you use the combo menu it is out of order again.
Thanks for the Craig it works a treat

Aug 11 '06 #3

P: n/a
"feeman" <fe*********@feehally128.karoo.co.ukwrote
I have gone into the table and put it in order,
but when you use the combo menu it is out
of order again.
By definition, the Records in Tables in Relational Databases are un-ordered.
You order them by sorting them in a Query, or retrieving with an SQL
statement containing an ORDER BY clause.

Larry Linson
Aug 11 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.