Primary and Secondary Sort of Sub-Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Thank You Douglas.

Douglas J. Steele said:
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.
Click to expand...
 
Back
Top