Primary and Secondary Sort of Sub-Form

[jehmsit]

I have 3 tables, EmployeeData, OrgData, ClubData. I have a form (it doubles
as the input for the tables) which displays the Employees information in the
main part of the form. It has a key field 'Track' which ties it to the
OrgData table which in turn has a key field 'Clubs' which ties it to the
ClubData table. An employee can belong to multiple Clubs. The last to
tables are displayed in a subform. They display the group the employee
belongs to and their review dates (up to 4 dates which = the 4 review fields).

How do I SORT the data to be displayed in the subform to reflect a
particular Club first and then followed by the remaining Clubs which are
sorted based on the most recent Review date?

 

[Douglas J. Steele]

Create a query that sorts the data the way you want it, and use the query as
the form's RecordSource rather than the table.

 

[jehmsit]

Thank You Douglas.

Create a query that sorts the data the way you want it, and use the query as
the form's RecordSource rather than the table.