display recordset data

S

Sean Hennessey

Hello all,

Can someone tell me how to bind an ado recordset to a form
in an access2003 mdb file?

I have a stored procedure that takes input parameters. The
only way I've found to call this is to use ADO. I can get
an ADO recordset that contains the data I'm looking for. I
need to find a way to display this data to my users. I
tried to set a form's recordset to this returned
recordset, but I get an error. Doing some research, I've
determined that Access MDB forms use DAO not ADO. I'm
assuming this is why I got the error when I assigned the
ADO recordset to the forms().recordset.

I hate to think that I'm going to have to create a DAO
recordset and copy the data from the ADO over to the DAO.

Does anyone have any pointers?

Thanks
Sean
 
Top