Requery a subform based on a table...

  • Thread starter Thread starter Clayq
  • Start date Start date
C

Clayq

I have a subform that contains records of test scores. I
want the scores to be sorted (and stay sorted) in
descending order by the date. My problem, is that the
records in the subform are pulled from a table, not a
query. Does anyone know how to get around the problem,
without having to change the recordsource of my subform?

Thanks, and have a nice day.

Clay
 
Clay, what's the problem with changing the form's RecordSource to a query or
SQL statement?

That is the obvious answer, and is just a matter of opening the form in
design view, opening the Properties box (view menu), and setting the
property.

If you feel like writing code instead, you could set the OrderBy property of
the form, and set OrderByOn to True in the Open event of the form.
 
Back
Top