Filter w/order by

[John Keith]

My form has the order by property set to "[Birth Date] DESC" so that the
youngest is first.

The initial load with out a filter displays the rows in the proper order.
Via code using an unbound textbox in the header section, the filter is set
and activated. The rows that show in the detail section all match the
filter, but the order by is seemingly ignored. How do make a filtered record
set being shown in the form continue to use the order by?

 

[John Keith]

Even though the help screens say that OrderByOn property is for reports...
This is also necessary for forms.

 

[Douglas J. Steele]

Use a query with the appropriate ORDER BY clause on it rather than the table
as the form's RecordSource.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Even though the help screens say that OrderByOn property is for reports...
This is also necessary for forms.

--
Regards,
John

My form has the order by property set to "[Birth Date] DESC" so that the
youngest is first.

The initial load with out a filter displays the rows in the proper order.
Via code using an unbound textbox in the header section, the filter is
set
and activated. The rows that show in the detail section all match the
filter, but the order by is seemingly ignored. How do make a filtered
record
set being shown in the form continue to use the order by?