Find Recordcount in Subform (1 Viewer)

[jmaty23]

I need to check the recordcount in a subform of a navigation frame form in VBA. Anyone know the proper syntax. I have tried multiple things but cant seem to get it. I would rather not use dcount.

 

[Pat Hartman]

One way is to add a control to the footer of the subform to count the records. Its RecordSource would be:
=Count(*)

Assuming you named that control - txtRecCount, then you would reference it as:

Me.txtSubRecCount = Me.sfrmYourSubform.Form!rxtRecCount