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

how to sort a combo box

P: n/a
Hi folks.

I'm doing a library system which contains a table caled "Member",
which in turn contains an ID key and the member's name. I have a combo
box which allows the user to pick a name from the combo box to view
that person's history of borowing books, etc. However, the combo box
is not sorted by name (its sorted by the ID key, which I kept hidden).
So how do I sort the combo box by name? Thank you.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 20 Apr 2004 21:25:16 -0700, so**********@hotmail.com (Aravind)
wrote:
Hi folks.

I'm doing a library system which contains a table caled "Member",
which in turn contains an ID key and the member's name. I have a combo
box which allows the user to pick a name from the combo box to view
that person's history of borowing books, etc. However, the combo box
is not sorted by name (its sorted by the ID key, which I kept hidden).
So how do I sort the combo box by name? Thank you.


Select the combo-box in form design. Right click and activate
PROPERTIES (if the first time you do this the PROPERTIES box closes,
just do it a second time and it will reopen). Select the DATA tab.
Select the ROWSOURCE line. Click the elipses to the right (three dots
"..."). Click on the SHOW check box below the field with the member's
name. Save.

mike

Nov 12 '05 #2

P: n/a
Ray
so**********@hotmail.com (Aravind) wrote in message news:<61*************************@posting.google.c om>...
Hi folks.

I'm doing a library system which contains a table caled "Member",
which in turn contains an ID key and the member's name. I have a combo
box which allows the user to pick a name from the combo box to view
that person's history of borowing books, etc. However, the combo box
is not sorted by name (its sorted by the ID key, which I kept hidden).
So how do I sort the combo box by name? Thank you.


Hello,

Set the name field to Ascending in the sort row for the
Row Source of your combo-box, whether it be a query or SQL.

Regards,

Ray
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.