Sorting Data in a Form

[Guest]

I have a form that pulls directly from a table (no query involved). How do I
sort the data by one of the fields in the form (i.e. month)?

 

[Douglas J. Steele]

Use a query with the appropriate ORDER BY clause.

 

[Damon Heron]

In the form's properties, under data, enter the field you want sorted by in
OrderBy. You then will have to right click when the form is open to apply
the sort order. If you always want the same order, then you can click on
the right of the record source field in properties, and create a "query"
that contains all of your fields and assign the sort order to the field you
want.

Damon

 

[UpRider]

In your form's properties, Data tab, the record source is probably your
tablename.
If so, change that to:
Select * from [TABLENAME] order by [MONTH];

The caps have to be your item names. Use the braces.
This SQL will take the place of a stored named query so that you won't need
one.

UpRider