Creating asending order

[josnow]

I want to sort the fields in my form so that the list box shows the information alphabetically. I have a form with Role and TeamMember which I want to have ascending. I have the following information:

Me.OrderBy = “[Role] ASC”
Me.OrderByOne = True

I’ve tried putting this code in several spot on the Role field properties of my form. What am I doing wrong?

[John_G]

Hi -

The sort order in a list box is independant of the sort order of the form itself. Your Me.OrderBy = “[Role] ASC” will sort the form, but not the list box. To see the list box alphabetically, you need an "order by" somewhere in the row source for the listbox itself. If the source is a query, you could put the sort in the query.

John

[josnow]

Hi John,

I have my form based on tables not on a query. Would I go under the property sheet for this list box and add code into that? If so, what would I add?

Joyce

Hi -

The sort order in a list box is independant of the sort order of the form itself. Your Me.OrderBy = “[Role] ASC” will sort the form, but not the list box. To see the list box alphabetically, you need an "order by" somewhere in the row source for the listbox itself. If the source is a query, you could put the sort in the query.

John

[John_G]

Hi -

You have me confused here - which is it you are having problems sequencing? As I understand it, you have a form, and on the form is a list box. The form is based on a table - but what is the source of the data shown in the list box? Is it the list box you want to have sorted alphabetically, the form records, or both?

Can you clarify this, please?

Thanks

John

[Mirslr]

if you are doing in SQL then
here is the easy example
SELECT * FROM name
ORDER BY LastName ASC

I see your mistake is that you should try to put ASC outside of parthesis

[josnow]

Hi John,

It is the list box that I want sorted alphabetically.

Joyce

[John_G]

Hi:

It's an easy solution, then - just use SQL as the row source for the list box, with an order by as required, e.g.

Select LastName, FirstName from MemberTable order by LastName

replacing the field and table names with the ones you are using.

John

[josnow]

Hi John, your query will not work since I need to build the query only in access forms. I'm using 4 tables to build this form. I don't know how to see this in SQL since I only can see the tables themselves. Is there a way in forms to get back into SQL so that I can do the order by?