how to sort a combo box

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.

On 20 Apr 2004 21:25:16 -0700, solaris_nite@hotmail.com (Aravind)
wrote:
[color=blue]
>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.[/color]

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

solaris_nite@hotmail.com (Aravind) wrote in message news:<6174ca57.0404202025.543b6fe@posting.google.c om>...[color=blue]
> 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.[/color]

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