How to refer to bound form's ADO Recordset ?

  • Thread starter Thread starter Albert
  • Start date Start date
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
 
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
 
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
 
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
 
Back
Top