Recordset count

[colinod]

Hi All

I have a form that is made from and sql querie and want to know if it is possible to remove the navigation stuff that access puts at the bottom and replace it with my own, i can do the navigation buttons but cannot find out how to do the recordset count, total records is the main one i am after

any help would be appreciated

[ADezii]

Probably the 2 easiest Methods would be:

1. Method 1
   

   DCount("*", "<Query that is the Record Source for your Form>")

2. Method 2
   

   Me.Recordset.RecordCount

NOTE: Method 2 will take into consideration any Filtering applied to the Record Source of the Form, whereas Method 1 will not.

[NeoPa]

You would also need to "GoTo" the end for large recordsets as .RecordCount is only populated correctly when all records have been processed.