Sorting in a Subform

[Randy]

I have a Main table with basic client data, and a Employments table
with data on employment information.

I have created a Main form and then included the Employments form as a
subform in the Main form.

I want it to sort the Employments subform in the Main form in
descending order by BeginDate. I tried putting
{Employments}.{BeginDate]in the Order By property but this did not
work.

How can I get it to sort on opening the form. Will a macro do it?
What should I do?

Thanks for any suggestions.

 

[Steve Schapel]

Randy,

I suggest making a Query based on the Employments table, using the Sort
within the query design to get the records in the required order, and
then using this query as the Record Source of your subform.

 

[Randy]

Thanks that worked great!!!!!!!!!!!