getting 'count' of filtered items?

[djc]

What is a good way to get the count of records present after a filter has
been applied? My setup: I have a 'main' bound form. I have a seperate
unbound form used to enter in criteria that ultimately becomes filter
criteria to use the FilterOn method for the 'main' form. On the other form
where the criteria is set I have a text box that I want to display the
number of items returned by the search. The search of course is just the
filter being applied.

how can I obtain the number of records in the current filter to display?

 

[Hugh O'Neill]

What is a good way to get the count of records present after a filter
has been applied? My setup: I have a 'main' bound form. I have a
seperate unbound form used to enter in criteria that ultimately
becomes filter criteria to use the FilterOn method for the 'main'
form. On the other form where the criteria is set I have a text box
that I want to display the number of items returned by the search.
The search of course is just the filter being applied.

how can I obtain the number of records in the current filter to
display?

Have a look in Help at the DCount() function. That ought to do what
you want.

hth

Hugh