bind ado recordset to report in ac97

[Guest]

Hi, everybody!

I know ac97 does not provide direct binding of an ado rs to a report. I want
to do it manually.
I have a form with a textbox and a button. On the button click event, I
passed the text box value to sql server and got a ado rs back.
My question is, am I able to pass the rs into the report, and in report's
open event wire up field by field like this
me!txtName.ControlSource = rs.fields("CustName")
....
Or do the data mapping in my form?

After all, is it possible to code this way? Any sample?

Thanks!

 

[Douglas J Steele]

As far as I know, it's not possible to do what you're trying to do.

You can use DAO to communicate with SQL Server.

 

[Guest]

Thank you for your reply!

When I got the data back as a recordset in DAO, what is the best practice on
binding them to a report in ac97?

 

[Douglas J Steele]

Use a pass-through query to get the data, and bind the query to the report.
While newer versions of Access will let you set the recordsource to a
recordset, Access 97 doesn't have that capability.