i have a search in a db...i want to

[sparky68]

i have a search in a db...i want to add on the form "x of y results found"...i have a query that gets search results but how do i get its count? and how do i count the number of records in the table to get the "y" number?

 

[RickSpr]

Open a DAO recordset on the query, do a MoveLast method call, and then get the number of records it selects from the recordset's RecordCount property.

Open a recordset on the table and do the same. Rick Sprague