I have posted this question over in the Access Project forum with no luck and thought I might have posted in the worng spot.
Anyway, I have an Access Data Project that I am trying to help with (the original developer has left). The users are wanting to open a report to print based on the record on the form. I do not have access to the SQL Server to change the views or stored Proc. but can get someone to if needed. In a .mdb I would just create a query and get the record info from the form, but I am having trouble do this using a SQL statement with ADO. I thought I would have been able to build a SQL statement and open a recordset and set the reports recordsource to the recordset, but I am having no luck. Any suggestions on how to do this with out access to the SQL server?
Anyway, I have an Access Data Project that I am trying to help with (the original developer has left). The users are wanting to open a report to print based on the record on the form. I do not have access to the SQL Server to change the views or stored Proc. but can get someone to if needed. In a .mdb I would just create a query and get the record info from the form, but I am having trouble do this using a SQL statement with ADO. I thought I would have been able to build a SQL statement and open a recordset and set the reports recordsource to the recordset, but I am having no luck. Any suggestions on how to do this with out access to the SQL server?
