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

Combo Box Order

P: n/a
I have about 9 records in a table. This is used as a combo box in a
number of tables. I want the data in the combo box to be in a
specific order; the first three records should be at the top then it
doesn't matter how the other reocrds appear.

Does anyone have any idea how this can be achieved?

Thanks so much,
Leee
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Fri, 16 Jan 2004 02:48:29 GMT, Leee <le********@earthlink.net> wrote:
I have about 9 records in a table. This is used as a combo box in a
number of tables. I want the data in the combo box to be in a
specific order; the first three records should be at the top then it
doesn't matter how the other reocrds appear.

Does anyone have any idea how this can be achieved?

Thanks so much,
Leee


Access has no idea what "first 3" means since records do not have any
intrinsic, defined order. If there's something identifiable about the data in
those records, you can certainly use that to sort them.
Nov 12 '05 #2

P: n/a
add a field to your table called sortOrder, and number 1 - n in the
order you want to see in the combobox

create a query that gives you the combo box fields, ordered by
sortOrder

use the query as the source to your comboxBox

Leee <le********@earthlink.net> wrote in message news:<33********************************@4ax.com>. ..
I have about 9 records in a table. This is used as a combo box in a
number of tables. I want the data in the combo box to be in a
specific order; the first three records should be at the top then it
doesn't matter how the other reocrds appear.

Does anyone have any idea how this can be achieved?

Thanks so much,
Leee

Nov 12 '05 #3

P: n/a
Thanks, that sorted my problem. Appreciate the help!

On 16 Jan 2004 04:51:46 -0800, le*********@natpro.com (Roger) wrote:
add a field to your table called sortOrder, and number 1 - n in the
order you want to see in the combobox

create a query that gives you the combo box fields, ordered by
sortOrder

use the query as the source to your comboxBox

Leee <le********@earthlink.net> wrote in message news:<33********************************@4ax.com>. ..
I have about 9 records in a table. This is used as a combo box in a
number of tables. I want the data in the combo box to be in a
specific order; the first three records should be at the top then it
doesn't matter how the other reocrds appear.

Does anyone have any idea how this can be achieved?

Thanks so much,
Leee


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.