Results 1 to 2 of 2
  1. 03-30-2011, 02:46 PM #1
    metube
    metube is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    3

    Entry count on subform (eg. "2/4" or '2 of 4")

    Hey guys,

    As per the title, I'm looking for a way to have a subform display the number of records associated with the record Im viewing in the main form.



    For example, a client may have multiple cases or files, which I have in a single form view in a subform. At the top I would like it to give the user an idea of how many entries there are and which of those they are viewing.

    Any ideas?
    Reply With Quote Reply With Quote
  2. 03-30-2011, 06:16 PM #2
    ajetrumpet
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    how about a DSUM() function in the cSource of a textbox?? use a main form control as criteria for the criteria section of it. choose a unique identifier
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. ComboBox "Select" and "DLookUp"
    By witooldas in forum Forms
    Replies: 0
    Last Post: 03-23-2011, 03:31 AM
  2. "Group By" causes "ODBC--Call Failed" error
    By kaledev in forum Queries
    Replies: 1
    Last Post: 03-09-2011, 02:43 PM
  3. Use of "%" dummy in connection with "like" function
    By paosav in forum Queries
    Replies: 3
    Last Post: 04-10-2010, 10:22 AM
  4. aSTR = Dir("C:\*.*") >> "Type Mismatch"
    By JGrant in forum Programming
    Replies: 1
    Last Post: 03-28-2009, 05:17 AM
  5. "Count" and "Countif" in Reports
    By JMantei in forum Reports
    Replies: 1
    Last Post: 06-20-2006, 02:20 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums