Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Posts
    150

    Unanswered: 1 of 10 records counter with the filter

    I am trying to have a counter at the bottom of the pickupsheet that when the filter is not on it is the RECORDCOUNT & " of " & DCount("*","Main")

    But how do I do this when the filter is applied?
    Any ideas?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    Use the OnFilter event and count the number of records in form.recordset object (as I recall....)

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Or - add the filter criteria to the criteria argument of the DCount function
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •