Count the number of records that show up in a Access form  
  Index ‹ Microsoft ISV Community Center Forums ‹ Visual Basic for Applications (VBA)
Author Message
GetCode
PostPosted: Visual Basic for Applications (VBA), Count the number of records that show up in a Access form Top
I need to count the number of records that show up in a Microsoft access form. The forms record source is defined dynamically in vb using a select query. I need to know how to count the number of records that show up in a form.


Microsoft ISV Community Center Forums3  
 
 
duck thing
PostPosted: Visual Basic for Applications (VBA), Count the number of records that show up in a Access form Top

Open the results of your select query as a recordset. Then move to the last record in the recordset, and get the RecordSet.RecordCount property. Does this work



 
 
GetCode
PostPosted: Visual Basic for Applications (VBA), Count the number of records that show up in a Access form Top
How do I do that

 
 
 
Index ‹ Microsoft ISV Community Center Forums ‹ Visual Basic for Applications (VBA)