Hi
I have completed an application using VB6 and DAO rather than ADO recordsets. There are various requirements to display the retrieved data on a Form (as in the Access Report Generator) for subsequent viewing and printing.
I am having problems getting the report - named 'drSubscriptionsLog' to bind to the recordset (which is populated and on the same form) to a DAO recordset - datSubscriptionsLog. MS Help suggests this can be done at Design Time. I have set the Recordset of the report to 'datSubscriptionsLog' - the recordset.
When I try to run the report using subscriptionslog.Visible = True (on a command button click-event) at the moment, I get the message 'Invalid Data Source'. Yet, the DAO record souce is perfectly valid and is open - for business!!
Any suggestions would be welcome. I havent used the Data Form object before and reference material seems very limited.
Many thanks in anticipation
I have completed an application using VB6 and DAO rather than ADO recordsets. There are various requirements to display the retrieved data on a Form (as in the Access Report Generator) for subsequent viewing and printing.
I am having problems getting the report - named 'drSubscriptionsLog' to bind to the recordset (which is populated and on the same form) to a DAO recordset - datSubscriptionsLog. MS Help suggests this can be done at Design Time. I have set the Recordset of the report to 'datSubscriptionsLog' - the recordset.
When I try to run the report using subscriptionslog.Visible = True (on a command button click-event) at the moment, I get the message 'Invalid Data Source'. Yet, the DAO record souce is perfectly valid and is open - for business!!
Any suggestions would be welcome. I havent used the Data Form object before and reference material seems very limited.
Many thanks in anticipation