Sorting subform info w/n form

[trstorer]

I have a subform which reflects all the action associated with a particular case. The main form (main case information) is sorted in reverse chronological order by the query that brings up those records that satisfy the search, i.e. keyword search based on file name.

The subform is based on the "linking field" of case number to reflect all the action. I want the action to be sorted in reverse chronological order for that particular case.

I've tried inserting the DateofAction field in the Order by Properties for the subform.

Any ideas?????

Thanks.

 

[Neal]

Does the information for the subform come from a query? You could set the query sort the same way you've set the query for the main form.

 

[trstorer]

The query is only based on the main case information. The subform info comes straight from that the Action table based on the linking field.

 

[Neal]

Build a query off the action table and include all the fields you need, including the one that links to your cases table. Then set the sort of the DateOfAction field as descending. Finally, make the query, instead of the table, the subform's Record Source.

 

[trstorer]

Thank you! Your suggestion works. I thought I had tried this before without success, so I must have missed a step along the way.