Sort order in a subform

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

How do I set the sort order in a subform using a field in the subform other
than the form/subform link field? I've tried using the name of the control
in the Order By property for the subform, but no luck.

Ivor
 
Ivor Williams said:
How do I set the sort order in a subform using a field in the subform other
than the form/subform link field? I've tried using the name of the control in
the Order By property for the subform, but no luck.
Click to expand...

Sorting in forms is most easily accomplished by binding to a query instead of
the table and adding a sort to the query.
 
Back
Top