[AccessD] Referencing Fields in Sub-Reports

Charlotte Foust cfoust at infostatsystems.com
Tue May 17 19:40:20 CDT 2005


Bad, John!  Bad, bad, bad! Go to your room.  ROTFL

Charlotte Foust


-----Original Message-----
From: John W. Colby [mailto:jwcolby at colbyconsulting.com] 
Sent: Tuesday, May 17, 2005 4:00 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Referencing Fields in Sub-Reports


May I suggest a global variable?  They must be good for something!  

<VBG>

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Boyd
Sent: Tuesday, May 17, 2005 5:59 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Referencing Fields in Sub-Reports


How can I reference values in textboxes that are located in sub-reports?
I have a report (rptMain) with 2 subreports (rptSub1 and rptSub2).  Each
subreport only contains 1 textbox.  I want to grab the values from each
textbox in the 2 subreports, and display a total of the values on my
main report, rptMain. I can't figure out how to enter the Control Source
of the textbox on my main report.  With forms, I would just use
"Forms!frmMain.frmSub1.Form.txtTextbox +
Forms!frmMain.frmSub2.Form.txtTextbox", or something of this nature.  I
can't figure out how to do this with reports.
 
Any ideas?
 
Thanks,
Mark Boyd
I/S Supervisor
McBee Associates, Inc.
610/964-9680 x15
 
-----------------------------------------
This message and any attachments are intended only for the use of the
individual or entity to which it is addressed and may contain
information that is privileged, confidential, and exempt from disclosure
under applicable law. If the reader of this message is not the intended
recipient, or the employee or agent responsible for delivering the
message to the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is strictly
prohibited. If you have received this communication in error, please
notify the sender by replying to this message, and then delete it from
your system.
-------------------------------------------
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list