Ms Access - Count records on a subform

Closed
PM - 22 Feb 2012 à 07:41
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 24 Mar 2012 à 18:47
Hello,

I need help writing the code for counting the number of records on a subform.

Subform = FrmSecTable
Mainform = MForm
Textbox = Txtcount

I have tried a few different ways but cant seem to get it to work. Also i dont think "Recordsetclone" works either.

Hope someone can help

Thanks in advance.



Access 2003

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
24 Mar 2012 à 18:47
is your subform tied to a recordset ?