Number of records displayed

[Crampton]

Hiya, Ive tried searching on this forum but cannot quite see what i am looking for.

I have a form with say 500 records in it, when a user performs a query search it finds say 250 of those records. I would like the form to display something like this: "Found 250 of 500 records"
( This is similar to the "="Page " & [Page] & " of " & [Pages]" you can display in reports )

Any ideas?

Thanks

 

[dcx693]

How does the query work? Is it a saved query, or is it a SQL query on the fly? Whichever, you can use DAO or ADO and the Recordset.RecordCount property to find out how many were found.

 

[Crampton]

Thanks for the reply dcx693

It is a query on the fly!!

Whereabouts do I put this Recordset.RecordCount property?

Should i add a text box?

Sorry but im not great on this topic.

Thanks again

 

[dcx693]

You might want to consider the far easier, though somewhat slower route of using DCount. Here's a link: count of records. Look it up in the Access online help.

Also, look up recordcount in the Access online help. Here are some links:
RecordCount
RecCount in Form Text Box

 

[Crampton]

Thanks for your help.

It worked fine