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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form and two Subforms 2
How to always get the top level form reference, when calling from any subform/subform... 0
Total in a subform 1
Unremovable horizontal scroll bar on subform 1
Expression is typed...... 2
Use field to update multiple fields 4
sort subform by text field 1
Click a subform field to open relevant form 5

Back
Top