[AccessD] Doing a find on a form bound to an ADO recordset

I have discovered that if you use the form's OrderBy property then the find does not work. 
Additionally it causes page faults when you try and close the form.

I ended up just re-pulling the ADO recordset ordered by the fields I wanted and then the find of the 
ADO recordset (and the form's recordset) works just fine.

John W. Colby
www.ColbyConsulting.com

On 8/13/2011 1:22 AM, jwcolby wrote:
> I want to do a find on an ADO recordset. The form is correctly bound to the recordset, I can see the
> records, edit them etc. but when I try to do the find using me.Recordset, I get an error:
>
> Data provider could not be initialized.
>
> If I try to dim an ADO recordset object and assign it to me.Recordset I get the same thing.
>
> And yet I originally set me.Recordset = SomeADORst
>
> Any clue what is happening or how to do what I am trying to do?
>
> If I dim an ADO recordset object and set it to the recordset, then assign that to me.Recordset, does
> my dimmed pointer point to the form's recordset?
>
> I'm confused.