Results 1 to 4 of 4
  1. #1
    sstrauss87 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2011
    Posts
    29

    Question Counting the records in a subform


    Hello,
    I was hoping someone could toss me some ideas. I have a form that is used to receive Items. When an item is received it already has a material code and a unique serial number. the form has a subform where the serial numbers are scanned in. there may be multiple items received therefore multiple serial number listed on the subform. I need a way to count the records. Thanks for any ideas.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    The SubForm Recordset has a Recordset.RecordCount property.

  3. #3
    sstrauss87 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2011
    Posts
    29
    Thanks for the reply, does each subform record get assigned an identity that i could refer too. For example, If I wanted to check and make sure that each Item on the subform has met a certain requirement before I let the user continue. How could I check each record

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    I would do the verification in the OnCurrent event of the SubForm itself, or maybe the BeforeUpdate event of each control on the SubForm. Maybe a combination of the two.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Subform Counting Items
    By ZJGMoparman in forum Forms
    Replies: 1
    Last Post: 04-12-2012, 03:25 AM
  2. Counting records
    By mjsabin in forum Access
    Replies: 1
    Last Post: 03-06-2012, 11:11 AM
  3. Counting No of records above the limit.
    By cap.zadi in forum Reports
    Replies: 5
    Last Post: 11-29-2011, 12:51 PM
  4. Counting Only Certain Records
    By jtphenom in forum Queries
    Replies: 9
    Last Post: 03-29-2011, 01:25 AM
  5. Counting Records
    By WhiteNite1971 in forum Access
    Replies: 1
    Last Post: 01-22-2011, 06:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums