Sort Order

[Ken Yanko]

Hello Group,

This may seem like a dumb question, but how do I go about displaying the
information from my table in ascending order in my form? I have set the
sort order in the table to Ascending based on CompanyName. However, the
form wants to display the data in the order in which it was entered - ID
(AutoNumber). I've tried to set the OrderBy setting in the properties table
to "CompanyName" (with quotation marks) with no success. Then I tried
[CompanyName] (with brackets), still no luck. What am I overlooking or
doing wrong?



Ken

 

[Rick Brandt]

Hello Group,

This may seem like a dumb question, but how do I go about displaying
the information from my table in ascending order in my form? I have
set the sort order in the table to Ascending based on CompanyName. However,
the form wants to display the data in the order in which it
was entered - ID (AutoNumber). I've tried to set the OrderBy setting
in the properties table to "CompanyName" (with quotation marks) with
no success. Then I tried [CompanyName] (with brackets), still no
luck. What am I overlooking or doing wrong?

The OrderBy property of a form does nothing unless the OrderByOn property is
also set to True. The second property os not shown in the property sheet and
can only be set from code or by the use of a menu or toolbar.

It's easier and more reliable is to bind your form to a query and explicitly add
sorting to the query design.

 

[Ken Yanko]

Thank you. I'll give it a try.

Hello Group,

This may seem like a dumb question, but how do I go about displaying
the information from my table in ascending order in my form? I have
set the sort order in the table to Ascending based on CompanyName.
However, the form wants to display the data in the order in which it
was entered - ID (AutoNumber). I've tried to set the OrderBy setting
in the properties table to "CompanyName" (with quotation marks) with
no success. Then I tried [CompanyName] (with brackets), still no
luck. What am I overlooking or doing wrong?

The OrderBy property of a form does nothing unless the OrderByOn property
is also set to True. The second property os not shown in the property
sheet and can only be set from code or by the use of a menu or toolbar.

It's easier and more reliable is to bind your form to a query and
explicitly add sorting to the query design.