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

Order records in ComboBox

P: n/a
Hi.

I have a ComboBox in a table (tbl1), which is populated by another table
(tbl2). The ComboBox "Row Source Type" is set to "Table/Query", and the
"Row Source" is set to "tbl2".

In this configuration, the records of tbl2 in are not ordered as desired
in the ComboBox field of tbl1. Can I order the records in ComboBox
somehow, without using a query as "Row Source" to order the records?

Thanks,

--
Georges Heinesch
May 7 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Georges Heinesch wrote in message <44********@news.vo.lu> :
Hi.

I have a ComboBox in a table (tbl1), which is populated by another
table (tbl2). The ComboBox "Row Source Type" is set to "Table/Query",
and the "Row Source" is set to "tbl2".

In this configuration, the records of tbl2 in are not ordered as
desired in the ComboBox field of tbl1. Can I order the records in
ComboBox somehow, without using a query as "Row Source" to order the
records?

Thanks,


If you by this means you have a table level lookup, then see the this
http://www.mvps.org/access/lookupfields.htm

This ins't exactly encouraged, as you can see, and many of the reasons
are listed there.

Much better to use comboboxes on forms, which is where you need them.

I assume the table level lookups has the same possibilities as ordinary
combos, that you can alter it's rowsource. Use a query/sql string with
an order by clause in stead of a table for rowsource.

--
Roy-Vidar
May 7 '06 #2

P: n/a
RoyVidar wrote:
...
I assume the table level lookups has the same possibilities as ordinary
combos, that you can alter it's rowsource. Use a query/sql string with
an order by clause in stead of a table for rowsource.


That's exactly what I did, and it works. However I thought there would
be a possibility to order the records if a table is used as "Row Source".

This is apparently not possible. But I wonder why, because the lookup
for the ComboBox could (technically speaking) also consider the sort
order of the table (tbl2, which is used for the ComboxBox in tbl1).

Thanks,

--
Georges Heinesch
May 7 '06 #3

P: n/a
Georges,
there really isn't a 'sort order' for a table. Table records are not really
ordered at all. When you look at a table, access creates a query in the
background to display the records. It is not possible to have any kind of
sort order without a query.

"Georges Heinesch" <no****@domain-not-valid.com> wrote in message
news:44********@news.vo.lu...
RoyVidar wrote:
...
I assume the table level lookups has the same possibilities as ordinary
combos, that you can alter it's rowsource. Use a query/sql string with
an order by clause in stead of a table for rowsource.


That's exactly what I did, and it works. However I thought there would
be a possibility to order the records if a table is used as "Row Source".

This is apparently not possible. But I wonder why, because the lookup
for the ComboBox could (technically speaking) also consider the sort
order of the table (tbl2, which is used for the ComboxBox in tbl1).

Thanks,

--
Georges Heinesch

May 8 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.