Access 97 subform - records not sorting by date

[sdkfz]

I have a sub form which records 'contact notes' with clients. Each record is a date of contact, a call notes memo field and person taking call.

The date of contact is set as a short date in both the underlying table and the form. I am trying to get the old contacts to be displayed in ascending (although knowing how to do it in descending order would be nice too) order. I appear to be incapable of figuring this out.

I have the property 'Order By' set to the field "date of call' what else is needed?

TIA

[doctorgonzo]

Let me see if I understand this correctly. The subform has the contact notes information, including the date. The "Order By" property of the subform is set to order by the date. Correct?

What is the data source for the subform? A table or a query?

[sdkfz]

Doctor,

The subform has the contact notes information, including the date. - correct it is a one to many relationship with a core customer data table with SSN as the primary key

The "Order By" property of the subform is set to order by the date. Correct? Yes

What is the data source for the subform? A table

[doctorgonzo]

If the name of the field is 'date of call', then "[date of call]" (including quotes, I think) should be in the Order By property field.

Another idea would be to make a query that is based on the table that orders the dates in ascending order, and then use that query as the data source for the subform.

[sdkfz]

I shall try the first idea tonight after all the users log off and then the second, thanks doctor