Order By Property

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

I have a form with a few subforms that is not ordering records, even though
the Order By property has been set. Other forms with the same Record Source
and the same Order By property work fine. Has anyone experienced this
problem; anything I should check?
Thanks,
Jake
 
I have a form with a few subforms that is not ordering records, even though
the Order By property has been set. Other forms with the same Record Source
and the same Order By property work fine. Has anyone experienced this
problem; anything I should check?
Thanks,
Jake
Click to expand...

First thing to check is the OrderByOn property: it should be True.

I've found that it's usually easier to simply base the form/subform on
a sorted Query.

John W. Vinson[MVP]
 
Hi John,
Thanks for your note. I determined the cause was a filter/sort that was not
saved with the form. Also for the record, the OrderByOn property applies to
reports; forms have an OrderBy property only.
Thanks,
Jake
 
Back
Top