469,150 Members | 1,960 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,150 developers. It's quick & easy.

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.
Sep 8 '10 #1
1 1285
Stewart Ross
2,545 Expert Mod 2GB
You can access the subreport's control values like this:

Expand|Select|Wrap|Line Numbers
  1. If Me![Your subreport name].HasData then
  2.     debug.print Me![Your subreport name].Report![Your control name]
  3. End If
  4.  
-Stewart
Sep 11 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Downstreamer | last post: by
5 posts views Thread by NOSPAM | last post: by
5 posts views Thread by ken | last post: by
4 posts views Thread by RP | last post: by
reply views Thread by Manikandan Pushkaran | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.