sorting within a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2000 with a form and a subform. Is there anyway of controlling (sorting) the order of records listed in the subform? I am entering grades, and it would be easier if the listing was ordered by most recent entry, so I could just copy the same class. [Note my class listing is part of a combo box]. Sometimes I think the class listing is alphbetical, and other times I have no idea in what order the records are being shown, its not by record ID number either
Ideas and help would be greatly appreciated
Also is there an easy way to go to the next record of the form while in the subform? Now I use the mouse and hit right arrow.
 
If your subform is based on a query, you can set the sort order in that
query (descending on the date field).

You can use Ctrl-tab to move from the subform to the main form (it will go
to the control after the subform control in the tab order). If the subform
is the last control in the tab order, then you'll go to the next main form
record.

--
Joan Wild
Microsoft Access MVP

John Wood said:
Using Access 2000 with a form and a subform. Is there anyway of
Click to expand...
controlling (sorting) the order of records listed in the subform? I am
entering grades, and it would be easier if the listing was ordered by most
recent entry, so I could just copy the same class. [Note my class listing
is part of a combo box]. Sometimes I think the class listing is
alphbetical, and other times I have no idea in what order the records are
being shown, its not by record ID number either.
Ideas and help would be greatly appreciated.
Also is there an easy way to go to the next record of the form while in
Click to expand...
the subform? Now I use the mouse and hit right arrow.
 
You can open the subform, sort on the field you want and save it.

Alternatively you can use a query or just a SQL statement as the
recordsource for the form.

If you click on the recordsource property, you'll see a build button (...)
to the right. This will open a query by example window. Double click on
the * field, and then double click on your date field. Remove the show
check for this field and in the sort row choose descending. Close the
window, and the recordsource will have a SQL statement.
 
Back
Top