RecordCount on Subform using ADO

[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

 

[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

 

[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!

 

[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!

Try:

[quoted text clipped - 6 lines]