Solved Me.subform.form.recordsetclone

[tt1611]

Hi All
I have a subform attached to a main form whose recordset is bound to a SQL Server stored procedure. I can get the sproc data to populate the subform just fine using

set subformname.form.recordset = sproc_rst

sproc_rst being an ADODB recordset.

However the very next line, I am trying to check if records exist in the subform and im using

[CODE]dim rsclone as recordset
set rsclone = me.subformname.form.recordsetclone

[/CODE]

The code breaks opening my ODBC datasources window prompting for an ODBC connection. I have been able to use this before so not sure whats changed in Access 2021. Any help on this would be appreciated.

Thanks

 

[theDBguy]

Hi. Not sure what happened either; but if you said it is literally the "next line", then perhaps just reuse the same variable?

Set rsclone = sproc_rst

Just a thought...

 

[tt1611]

Hi. Not sure what happened either; but if you said it is literally the "next line", then perhaps just reuse the same variable?

Set rsclone = sproc_rst

Just a thought...

AND THAT WORKED JUST FINE.

Thanks for your help and very quick response. Very weird this worked in prior office versions. Have a great day.

 

[theDBguy]

AND THAT WORKED JUST FINE.

Thanks for your help and very quick response. Very weird this worked in prior office versions. Have a great day.

Glad to hear you got it to work. Good luck with your project.

 

[MajP]

I have not tested it, but I am wondering if the recordsetclone property can return an ADO recordset. The literature hints that this is for DAO recordsets.