Datasheet Subform Won't Sort

  • Thread starter Thread starter yussi1870
  • Start date Start date
Y

yussi1870

Hello,

I have a form called Tasks. This form has a subform called
Descriptions. The Task form has a control which is bound to the ID
field in the Tasks table. The ID field is an AutoNumber primary key.
The ID field is the Link Master Field for the Subform. The Link Child
Field is Description_ID. The Subform is bound to a table called
Descriptions with the following fields: Date, Description_ID and
Description. Description_ID in the Descriptions table is ID in the
Tasks table. Each Description_ID can have more than one Description
on a given Date and can have more than one Date. For this reason all
three fields are a primary key. The Date field is Indexed (Duplicates
OK). The other two fields are not.

When I open the Descriptions table the data is sorted by Date. This
is what I want.

When I open the Task form which has the Description subform datasheet
the data which is displayed (Date and Description) is usually sorted
by date but for some IDs the data is out of order. Any ideas how to
fix this?
 
Instead of using the table Descriptions as the recordsource for the subform,
use a query that is based on this table. In that query, specify the sort
order that you want. Then the subform will display your records in that same
order.
 
Back
Top