Resort an open recordset

[John Dumay]

Hi All,

In my cose i open a recordset called "rsdata" based on a query. In the
original query the data is sorted ascending on a field "Q1Score" which is
fine for the first bit of code. I want to now utilise the same data set but
now sort on field "Q2Score". How do I resort the recordset based on this
criteria without closing it - or do I need a new query?

Your assistance is appreciated.

Regards,

John Dumay

 

[J_Goddard via AccessMonster.com]

Hi -

You don't need a new query, but you do need to re-create the recordset using
SQL:

set rsdata = db.openrecordset("Select * from MyQuery order by Q2Score")

should work fine, if you want all the fields from the query.

John

 

[John Dumay]

Hi John,

Thanks for the input. Works a treat.

Regards,

John Dumay