<div>
or, assuming that <br />
<br />
DetailCount = me.recordsetclone.Recordco<wbr />unt<br />
<br />
I use this a lot for sub-forms that contain datasheets, where I want to display the count of records displayed in the datasheet. &nbsp;In this case, I also use code similar to Gustav's and use the datasheet forms ApplyFilter event to call this code again, so that the count stays up-to-date, even after the datasheet has been filtered.
</div>


or, assuming that

DetailCount = me.recordsetclone.Recordcount

I use this a lot for sub-forms that contain datasheets, where I want to display the count of records displayed in the datasheet.  In this case, I also use code similar to Gustav's and use the datasheet forms ApplyFilter event to call this code again, so that the count stays up-to-date, even after the datasheet has been filtered.

<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
MsAcccess 2003<br />
ODBC Connection : Linked Tables<br />
<br />
Query: &quot;PageLog&quot; Form &quot;Main&quot; lable &quot;lblDetail&quot;<br />
What i am trying to do is have the label caption say There are&quot;&quot;&quot;&quot;records entered into system...<br />
<br />
I have tried DCount but am getting no where...<br />
<br />
Mickey
</div>
</div>


MsAcccess 2003
ODBC Connection : Linked Tables

Query: "PageLog" Form "Main" lable "lblDetail"
What i am trying to do is have the label caption say There are""""records entered into system...

I have tried DCount but am getting no where...

Mickey

How To Display The Record Count Of A Query On A Label On  A Form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.