Record count of a subform in another subform

C

CG_Squared

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
*
 
Top