ADO/SQL Server RecordSet and the OrderBy Property
I have an issues and can't seem to find any info on the web about it. Here is what I'm doing.
1. Open a Recordset using ADO via a stored proc in SQL Server.
2. Set the forms recordset = to the ado recordset.
This works, not problems here.
I want to set the OrderBy property to a preset string. This works if the form has not been bound to the ADO recordset, but if the form is bound and I change orderby and change the orderbyon property to true, I get the error "Data provider could not be initialized." Has anyone ran across this before.
Currently, I'm killing the datasource for the form, and then reattaching the recordset...seems like a lot of work.
One other note. The form is in datasheet view and if I use the mouse and the popup menu to change the sort order (orderby property) it works...it's the same value that I'm setting it to programatically.
Thanks in advance,