Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243

    Unanswered: Get the number of records on a subform

    Hi all,

    I have a continuous subform with a couple of records.
    How can I get the number of records shown in this form.

    Thanks
    Last edited by artemide; 06-05-03 at 10:40.

  2. #2
    Join Date
    Nov 2002
    Location
    Hamilton,Ontario
    Posts
    132

    Re: Get the number of records on a subform

    Originally posted by artemide
    Hi all,

    I have a continuous subform with a couple of records.
    How can I get the number of records shown in this form.

    Thanks
    http://msdn.microsoft.com/library/de...rmsReports.asp

  3. #3
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188

    Re: Get the number of records on a subform

    Originally posted by artemide
    Hi all,

    I have a continuous subform with a couple of records.
    How can I get the number of records shown in this form.

    Thanks
    pls try these codes in main form:

    dim number_of_records as long
    number_of_records=MainFormName!SubFormName.form.re cordset.recordcount

    hope this helps
    qha_vn

  4. #4
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    personally i'd use Dcount but thats me:-)
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  5. #5
    Join Date
    Aug 2002
    Location
    Melbourne, Australia
    Posts
    111

    Thumbs up count records in sub form

    Have a look at my attachment.

    The subform is not very nice, as I have left the controls so that you can see them in design view.

    You can have the count showing in the subform, but it does not look as good as this. You can move that the "total of sub form" anywhere on the main form, including header and footer.

    HTH


    Regards
    Attached Files Attached Files
    Regards,



    John A

Posting Permissions

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