Is there a VBA method that will yield the number of records in a group? I only see three with "Me." auto, "GroupHeader", "GroupFooter" and "GroupLevel".
Is there a VBA method that will yield the number of records in a group? I only see three with "Me." auto, "GroupHeader", "GroupFooter" and "GroupLevel".
by groups, do you mean within the context of a report?
Why do you need VBA? Don't see how referencing those entities will help with counting records.
If you are building a report, use report grouping and sorting settings. Put a textbox in group footer with an expression: =Count(*)
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks, that's all I needed.Put a textbox in group footer with an expression: =Count(*)
Yes, I need to toggle some header/footer visibility when there's only one record in the group.