Record count of a subform in another subform

G

Guest

I have a form which contains a subform (subQUOTE) on that subform I have
another subform (subQUOTEBREAKS). I have tried to place a field on subform
(subQUOTE) that has the count of records on the subform (subQUOTEBREAKS)
using the following in the control source field:
=[subQUOTEBREAKS].Form.RecordsetClone.RecordCount
this yields #Name?

What am I missing? The reason I want this count is so the user will know
whether or not to expand the item in subform (subQUOTE) to see if there are
any records in the subform (subQUOTEBREAKS). If there is a better way ...
please share.

Thanks
 
S

strive4peace

use Recordset not RecordsetClone

=[subQUOTEBREAKS].Form.Recordset.RecordCount


Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 

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

Similar Threads

How to always get the top level form reference, when calling from any subform/subform... 0
MS Access 2007: Calculated field based on subform: 1
Testing Subform Records to make button visible 1
First Subform record gets modified when closing form 3
Trouble associating parent form record to subform's record 1
VBA Syntax for subform record source change 6
Copy data from 1 subform to another subform 2
Set focus in a specific record within a subform 1

Top