473,386 Members | 2,114 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 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 1357
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

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

Similar topics

9
by: Downstreamer | last post by:
Design is as follows: A form for the user to input criteria to be used as the where part of the report's recordsource. This includes a multiselect list box as part of the criteria selection. ...
3
by: kmacon | last post by:
I have a form that contains a command button. The command button's OnClick event builds a report using the CreateReport and CreateReportControl functions and then opens the main report. I set...
5
by: NOSPAM | last post by:
I want to write a class that has multiple values associate to it public class Person { public string FirstName {get; set;} public string LastName {get; set;} public DateTime Date {get; set;} }...
5
by: ken | last post by:
Hi, Why can't I do this in the report activate section of my main report? I have a main report, and a subreport on it. The idea is that if the subreport has a certain value in a control within it,...
0
by: C | last post by:
Hi, I have a main Report which has a SubReport. This SubReport also has a SubReport. I set the data of my main Report and Subreport through code DataSet dsMainReport =...
4
by: RP | last post by:
I have a class file (Global.cs) containing following variable: Public Int32 TotalRecords=0 I have a Windows Form from where I am assigning a value to this value as below: private void...
7
JustJim
by: JustJim | last post by:
Just when I thought I was getting my head around Null values.... I have a report with three sub-reports, on each sub-report footer I count how many records in the subreport. No problemo. On...
0
by: Manikandan Pushkaran | last post by:
Dear All I made a Header Report and a Detail report, the detail report having a report parameter, the header report am refreshing with a value when we select a value from the drop down and...
2
by: Taftheman | last post by:
Hi, I have created a pop up using js and returns a value for me to process. I have got it working. I now need to do it again for another button. The value return will be processed differently. But as...
8
by: codicecrm | last post by:
Hello! I am trying to apply conditional formatting to several subreports within a main report (Charlie) with code - because I have four conditions. When the value of txt_SafetyFundingNumber is ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.