recordsource vs recordset on report

[jordanking]

Hello,

I am using an Access adp front end with SQL server back end.

When I set a report recordsource to a query/view on the sql server, the report works fine.

However, if i try to dynamically set the recordset property of the report, the report opens with the right amount of detail lines, but none of the data is visible. The recordset is open and if i debug and step throught it, and reference the recordset fields from the immediate window, that values are all there.

Does anyone have any idea why using a recordset now makes the data invisible in a report?

here is the code I have used numerous times in this current project that has worked on all other reports except this one

Private Sub Report_Open(Cancel As Integer)
    
    Dim rs As ADODB.Recordset
    Set rs = New ADODB.Recordset

    ''' clone recordset from another subform
    Set rs = Forms!frmDriverList.Form!fsubDriverList.Form.RecordsetClone
    Set Me.Recordset = rs
    
End Sub

.....
I'd rather be surfing