[AccessD] subform bound to ado recordset throws error

John,

I learned early not to try and mix DAO and ADO in the same routines.
I always used the parent form's events to set the source for the
subform with ADO.  Maybe I missed the post where you specified the
code that was going sideways.

Charlotte Foust



On Wed, Mar 16, 2011 at 12:36 PM, jwcolby <jwcolby at colbyconsulting.com> wrote:
> This seems to be a known issue without a resolution.
>
> http://www.utteraccess.com/wiki/index.php/Using_ADO
>
> It was occurring specifically when I was trying to use the subform linking.
>  It really appears that when any form is bound to an ADO recordset there are
> a host of issues with the RecordsetClone (which is DAO) and that perhaps
> recordsetclone is used internally by DOA to support the form.
>
> John W. Colby
> www.ColbyConsulting.com
>