Counting Total Records and Filtered Records

[shwin]

Hi All!

I have a form which has a filter by form feature. The navigational bar at the botton of the form does display how many records I have and also how many records have been filtered, but I would like to display this number on the top of the form. In other words, I would like to record how many records were filtered out and how many records exist total. I think there should be an easy way to do this but I can't get it to work. Any help would be appreciated!

Thanks guys!

 

[PHV]

Take a look at the Recordset.RecordCount property and at the DCount function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244