How to refer to bound form's ADO Recordset ?

A

Albert

Hello expert, I use AccessXP.

If my form is bound to ADO recordset, What is the syntax I use to refer to
that recordset ? I ask because I know only Me.RecordsetClone which return
DAO recordset. To return ADO recordset, What property I need ?

Regards,
Albert
 
K

Ken Snell

Any reason why you can't refer to the Recordset property of the form itself
(i.e., Me.Recordset)? or to the original ADO recordset object itself?

--
Ken Snell
<MS ACCESS MVP>

Hello expert, I use AccessXP.

If my form is bound to ADO recordset, What is the syntax I use to refer to
that recordset ? I ask because I know only Me.RecordsetClone which return
DAO recordset. To return ADO recordset, What property I need ?

Regards,
Albert
 
D

Dick Penny

Ken,
Could you plseas tell me how to get Me.recordset (DAO) into a Report? Or
into a table which I could then use to drive the report?

I know that Set rst = Me.recordset in form code, and then in report open
event Me.recordsource = rst.name
does NOT work. You get the WHOLE table behind the form rather than the
current records being displayed by the form.

Dick Penny
 
L

Larry Linson

Eh? Why would you want to use a Form's recordset as the RecordSource for a
Report. Can you not use the Form's RecordSource and, if necessary, the
Me.Filter property of the Form, to create a DoCmd.OpenReport? Or, indeed,
pick up both from the Open event of the Report (if it is always initiated
from the same Form and if you'll leave that Form open until the Report's
Open event).

Larry Linson
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top