Does sorting a DAO.Recodset actually do anything? 1

[ponderdj]

Hi,

I have a form that uses sets a DAO.Recordset from a DAO.QueryDef. That recordset is then used to populate a Treeview. I want to set the recordset once, then use a recordsetclone and sort it based on different fields to repopulate the treeview.

I've used

rst.Sort = "[Field] Asc"

but it doesn't seem to sort the field at all, I've checked using debug.print and by looking at how it populates the treeview... it seems random.

Thanks

 

[PHV]

You have to use another recordset:
With rst
.Sort = "[Field] Asc"
Set rstSorted = .OpenRecordset
End With

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ponderdj]

That's it! Thanks PHV. Man, I was almost there, I just forgot to change the rst that gets passed to my treeview populating function. At least I was on the right path...

Thanks again, PHV.