Requery a subform based on a table...

[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

 

[Allen Browne]

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.

 

[support]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting

 

[support]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting