Recordcount of a subFrm ? 1

[Bresart]

Hi, one of the forms in a DB is a popup simple one with a child continuous subform. A textbox in the parent form must show the records number there is in the subform not only in the shown main record but in all main records.

With the control source property of the textbox set to:

=[Forms]![frmName].[secControl].[Form].[RecordsetClone].[RecordCount]

the textbox shows only the number of records in the subform in the current main record, but not the number of records in the subform in all main records. Also, when browsing to another main record thet textbox shows #Error.

Any idea for going around that?

Thank you.

 

[PHV]

Have a look at the DCount function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Bresart]

Thank you PHV. It works with control source property set to:

=DCount("[anyfieldname]";"tablename";"[visible]=Yes")

being the last argument any selection criteria for that table.