SteveL13
asked on
How show filtered record count in a textbox on a form
I have a textbox on a form which display the total record count in a table. But I also want to have a textbox on the form that shows the filtered record count on the form.
Here's my default value code for the first textbox.
=DCount("[ID]","tblImportR ecords")
But what would the code be for the filtered record count?
Also, would it be in the afterupdate event of the form itself?
Here's my default value code for the first textbox.
=DCount("[ID]","tblImportR
But what would the code be for the filtered record count?
Also, would it be in the afterupdate event of the form itself?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In the Form.ApplyFilter event procedure
Me.yourtextboxname = Me.RecordsetClone.RecordCo unt
Me.yourtextboxname = Me.RecordsetClone.RecordCo
Open in new window