Sorting A Subform

[Ty Archer]

I have a database that tracks employee's time (days & hours worked). The
main form has personal information, while the subform has the time
information. I'm using employee hours as the primary key, and would like the
subform to be sorted by dates. The main form will be sorted by employee
number, however, I want the subform to be in chronological order. How can I
do this? Thanks very much.

 

[Rick Brandt]

I have a database that tracks employee's time (days & hours worked).
The main form has personal information, while the subform has the time
information. I'm using employee hours as the primary key, and would
like the subform to be sorted by dates. The main form will be sorted
by employee number, however, I want the subform to be in
chronological order. How can I do this? Thanks very much.

Generally the best way to get a particular display order in a form is to
bind it to a query based on your table rather than the table directly, and
then inculde a sort in the design of that query.