Sort Order not reflected in Form's Recordset

[MrSuaveh]

All,

Unfortunately I have a client that still uses Access 2000. That's not so
bad, but there is one feature that I cannot find a way to add and it only
fails in Access 2000.

When we create an ADO recordset and then bind it to an Access 2000 form we
can't find a way to sort the records. For some reason when the rs.Open
<source> uses a <source> string where the Len() is greater than 256
characters then we get a 'Class Not Registered' error the next time we click
anywhere on the form. This seems to prevent the OrderBy and OrderByOn from
working.

BTW, this isn't for just 1 form on 1 workstation, that is consistent for 30+
workstations on 6 different forms.

Anyway, so I say heck with OrderBy, I'll do something like this:

dim rs as new adodb.recordset
set rs = me.recordset
rs.sort = "Field"
set me.recordset = rs

However, this also does not work. If I loop through rs it shows the correct
sort order. After binding it to the form though the correct sort order is
not reflected on the form.

So waz up? Anyone ever run into this funkiness? What obvious things am I
missing? Please illuminate.

Thanks,
Rick

 

[Guest]

Did you also explicitly set the OrderByOn=true?
Did you get the latest servicepacks?