How can you expose a subreport value in VBA code

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • valencia11
    New Member
    • Sep 2010
    • 2

    #1

    How can you expose a subreport value in VBA code

    I have a report with a subreport on it. How can I expose the values in the subreport in VBA code? I think what I need is the syntax to get to the values. I know how to use hasdata, to check if data is present. Just need to know how to expose the values in the subreport. TY.
  • Stewart Ross
    Recognized Expert Moderator Specialist
    • Feb 2008
    • 2545

    #2
    You can access the subreport's control values like this:

    Code:
    If Me![Your subreport name].HasData then
        debug.print Me![Your subreport name].Report![Your control name]
    End If
    -Stewart

    Comment

    Working...