Record Count

• • Reply

  19 years ago

  by AntonyWilson

  AntonyWilson

  , Saudi Arabia

  Joined 19 years ago

  Can anyone tell me if it is possible to have a text box displaying the record count of a filtered recordset?

  Report abuse
• • Reply

  19 years ago

  by James Crowley

  James Crowley

  London, United Kingdom

  Joined 20 years ago

  I think u need to do .MoveLast, and then u can use .RecordCount (if you're using ADO)

  Report abuse
• • Reply

  19 years ago

  by gringod

  Gringod

  London, United Kingdom

  Joined 19 years ago

  if you're using a data from a table in a form, this should work:
  

  
  

  Quote:

   
  Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)
     Dim rsTest As Recordset
     Set rsTest = Me.RecordsetClone
     
     rsTest.MoveLast
     txtCount = rsTest.RecordCount
  End Sub
  

  
  

  
  there is probably a neater way of doing this, and it may well slow your system down if you have got a large recordset.

  Report abuse