Counting filtered records

[torok]

I'm filtering records based on what's in a combo box, and in the nav bar it shows "record x of 1 (filtered)". I want to get rid of the nav bar, but put the number of filtered records in a text box. Anyone know how to get that number for a control source?

Thanks!

 

[Jonathan Kok]

In the form footer, create a textbox ([txtRecordCount]) that calculates the total records, ie:

=Count(*)

Reference this textbox in your form, ie, create another textbox and set the source to [txtRecordCount] or whatever you named the above field.