Number of results

  • Thread starter Thread starter TemporaryUser
  • Start date Start date
T

TemporaryUser

Hi,

I would like to be able to easily find out the amount of records that a
query has returned from, a form, preferably putting the result into a
variable, which can then be referenced from the form.

Thanks a lot
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Create a Recordset Clone on the form's Recordset. Then

rsClone.MoveLast
Me!txtCount = rsClone.RecordCount

See Access VBA Help articles on RecordsetClone (DAO) or Clone (ADO).

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQVRydIechKqOuFEgEQIeQACeLz5CnheZ1e5NFNx9Wu8XCEcdLdcAn2Gr
rvQEh+1XxYiqy5Z/fSY9OVqu
=wUaO
-----END PGP SIGNATURE-----
 
Back
Top