View Full Version : Counting filtered records


torok
04-06-2002, 01:05 PM
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
04-08-2002, 10:34 AM
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.