[AccessD] finding # of filtered records

Lyle,

On the navigation bar at the bottom it tells you how many records were
returned.  If it has a form filter, then to the right of the nav buttons
will appear the word "Filtered."

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us
(SELECT * FROM users WHERE clue > 0)


-----Original Message-----
From: lyle.hannum at co.wake.nc.us [mailto:lyle.hannum at co.wake.nc.us] 
Sent: Thursday 2003 Feb 20 11:30
To: accessd at databaseadvisors.com
Subject: [AccessD] finding # of filtered records

Hi all,

I would like to find the # of records returned when a form filter is
applied in Access 2000. My forms controls disappear when no records are
found :(  I plan to do my check in the forms Apply Filter event. Thanks.

Lyle Hannum