472,103 Members | 2,209 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,103 software developers and data experts.

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 1318
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
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.