Sort order in a subform

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
 
R

Rick Brandt

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.
 
Top