Sorting in Access?

[Neil Hindry]

I wonder if you can help me.

I have been using the very basic functions of Access XP for a while now but
I have just started delving into forms etc.

I have created a form to enter my data and I have a couple of pull down
menus (I think they are called Combo boxes) so that I can only select from a
list of data for that field. What I cannot seem to do is make this list
appear in alphabetical order.

One of the pull-down menu lists is from a table, I sorted that table
alphabetically but it does not alter the way the list is shown in the
pull-down menu.
How can I make the list in the pull-down menu appear in alphabetical order?

Also, relating to sorting, I know how to sort a table by having the cursor
in the field to sort by then selecting Records->Sort-> then either Sort
Ascending or descending.
However, I do not know how to do a sort with a secondary field just in case
the first field has identical entries.
Could someone please tell me if this is possible in Access XP and how it is
done?

I hope you can understand what I mean as I don't know all the correct
terminology.

Any help or information will be gratefully appreciated.

Thanks!

[Rog]

Tables in Access have no intrinsic sort order. Base your combobox on a
query and select sort ascending for the field that populates it.

[Roger]

create a query based on your table, then you can sort many fields,
ascending / descending

then use that query as the source to your comboxbox

"Neil Hindry" <n_nospam_hindry@_nospam_hotmail.com> wrote in message news:<42**********************@news.zen.co.uk>...

I wonder if you can help me.

I have been using the very basic functions of Access XP for a while now but
I have just started delving into forms etc.

I have created a form to enter my data and I have a couple of pull down
menus (I think they are called Combo boxes) so that I can only select from a
list of data for that field. What I cannot seem to do is make this list
appear in alphabetical order.

One of the pull-down menu lists is from a table, I sorted that table
alphabetically but it does not alter the way the list is shown in the
pull-down menu.
How can I make the list in the pull-down menu appear in alphabetical order?

Also, relating to sorting, I know how to sort a table by having the cursor
in the field to sort by then selecting Records->Sort-> then either Sort
Ascending or descending.
However, I do not know how to do a sort with a secondary field just in case
the first field has identical entries.
Could someone please tell me if this is possible in Access XP and how it is
done?

I hope you can understand what I mean as I don't know all the correct
terminology.

Any help or information will be gratefully appreciated.

Thanks!