Clipper2000
Programmer
Hi,
In MS Access, we normally supply an Access SQL query in the Report_Open event such as:
Code:
Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = "QryString"
End Sub
In VB6 and VB.NET, Crystal Reports etc, we can initiate an ADO object, fill the ADO recordset with records and manipulate the records until our heart's contend. Then we map the recordset object to the report template "on the fly"
Given that Access's Me.RecordSource only takes an Access SQL definition as the recordsource, is it possible to concoct a method to map an ADO recordset to an Access report "on the fly"?