RecordCount on Subform using ADO

D

Debbie

Hello all,
I am using ADO and I need to get the record count for a subform within a
main form. I see lots of appends using the recordset clone when using DAO
but recordset clone is not supported under ADO. Does anyone know how I can
do this? Thanks,
Debbie
 
K

kingston via AccessMonster.com

Try:

Me.SubFormName.Form.Recordset.Recordcount

Hello all,
I am using ADO and I need to get the record count for a subform within a
main form. I see lots of appends using the recordset clone when using DAO
but recordset clone is not supported under ADO. Does anyone know how I can
do this? Thanks,
Debbie
 
D

Debbie

Thank you - I tried it but it says that the property/method is not supported.
I have a feeling I cannot reference a form's recordset at all, that's the
part that isn't supported under ADO. Thank you anyway!
 
K

kingston via AccessMonster.com

Check your references by opening a VB editor window and selecting Tools-
References... I'm positive that this works in ADO as I use this in an A2000
database that has DAO turned off by default.
Thank you - I tried it but it says that the property/method is not supported.
I have a feeling I cannot reference a form's recordset at all, that's the
part that isn't supported under ADO. Thank you anyway!
[quoted text clipped - 6 lines]
 

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